Need help with criteria selection within Subreports

  • Thread starter Thread starter Irene Jefferies
  • Start date Start date
I

Irene Jefferies

I have a report that is built using multiple subreports
on it, all that run off queries to get specific results.
I want the main report and the subreports to run by a
certain period i.e. by the week say. The only way I can
think to do it is to put a date parameter in each query
but then all the parameter boxes show up for each report
(there are four) whenever you want to run it. Is there a
way to get all four of the subreports to print by the
same criteria without putting parameter selection boxes
into each of the queries. Any help greatly appreciated.
IEJ
 
-----Original Message-----
I have a report that is built using multiple subreports
on it, all that run off queries to get specific results.
I want the main report and the subreports to run by a
certain period i.e. by the week say. The only way I can
think to do it is to put a date parameter in each query
but then all the parameter boxes show up for each report
(there are four) whenever you want to run it. Is there a
way to get all four of the subreports to print by the
same criteria without putting parameter selection boxes
into each of the queries. Any help greatly appreciated.
IEJ

.
Click to expand...
I use a Pop Form with two text fields for beginning and
ending dates and a command button. In each of the queries
date field criteria you can then reference the form like
this:

Between [Forms]![frmYourFormName]![txtBeginingDate] And
[Forms]![frmYourFormName]![txtEndingDate]
 
Back
Top