multiple pivots on one report

[colbecd]

hi all

I have put 3 pivot tables on one report which are created from a query with criteria to input to and from dates which work however when I run the report it asks me to enter the dates about 15 times.

my questions is this... is there away I can link the criteria question so the I can just enter the date once?

apologies but new to access and I don't know what to do.

 

[xenou]

In general you get pop ups when you put a parameter in you query, which can be seen in the difference between these two queries, the first one will return results immediately but the second will ask the user for input with a popup dialog:
select * from MyTable where ProductID = "P001"
select * from MyTable where ProductID = [Enter a Product ID]
for more info see:
Creating Parameter Queries | Database Solutions for Microsoft Access | databasedev.co.uk

Note that I prefer to specify parameter data types for all such parameters:
https://support.office.com/en-us/ar...-reports-8209EB5C-1589-42E2-9B20-4181F4C7A356 (see the specify parameter data types section)

So your particular issue is likely that you have such a parameter in one of your queries. Being asked for input 15 times is, however, a lot. You may be invoking one query very many times.

You'll have to find that query (or those queries), and instead of using a parameter that requires user input in a dialog, you need to provide the date some other way. Probably the most common is to have the value in a form or report field that can be used by the query:
select * from MyTable where ProductID = [Forms]![MyForm]![txtProductID]