View Single Post
  #1  
Old May 4th, 2010, 04:34 PM posted to microsoft.public.access.queries
Leath
external usenet poster
 
Posts: 1
Default Duplicate prompts in crosstab query and subsequent report

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!