Duplicate prompts in crosstab query and subsequent report
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.
--
Build a little, test a little.
"Leath" wrote:
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!
|