Duplicate prompts in crosstab query and subsequent report

  • Thread starter Thread starter Leath
  • Start date Start date
L

Leath

I have a crosstab query in which I am prompting for a date range (Between
[Enter Start Date] and [Enter End Date]). When I run this report it prompts
me multiple times for the date range.

For example: I have a report pulling from one crosstab query which contains
10 graphs. The report prompts me 10 times for a start and stop date.

How do I design the crosstab query to only prompt once for the entire
report?
(it does the same thing if I prompt for other parameters also and isn't
limited to graphical reports - it will do multiple prompts for list-type
reports also)

Thanks in advance!
 
Use an unbound form to enter the data for the query criteria.
Refer to the text boxes on the form like this --
[Forms]![YourFormName]![TextBoxname]

Declare these as DateTime datatype in the crosstab query.
 
Back
Top