Sub report question 1

[ptrifile]

I have a blank report that has about 5 sub reports on it....Those 5 reports all pull from the same query and it reports on a date range, but i have to enter that date range in 5 different times, is there anyway around this?

Thanks!

Paul

 

[Onyxpurr]

Have you tried setting that date range as a parameter under the "Query" menu item in the query design view??

 

[ptrifile]

Yes I have done that, however it still asks me to enter the date range for each sub report when the report is run.

Paul

 

[glalsop]

You could place a text box on a form, and enter the date once in the text box. In all 5 querys, reference the text box in the criteria section of the date field:

Between [Forms]![YourFormName]![txtStartDate] And [Forms]![YourFormName]![txtEndDate]

-Gary

 

[dhookom]

glalsop gets a star for his contribution to the SOP Club (Stamp Out Parameters). Using form controls provides many more features than parameter prompts.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.