If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|