Report parameters

R

Ronny84

I have built a database in which I have 3 quieries. I have pulled the three
queries together on to one report, using 3 separate subreports. The three
quieries all have the same parameters, [Report Month (mmmyy)] and at the
moment when I run the report it asks me to enter the Report Month 3 times,
once for each query. Is it possible for me to combine these so that I only
need to enter the parameter once and it will apply iy to all the queries.

Also I want the report to display the Month entered in its title.

Any help would be greatly Appreciated.

Thanks
 
J

Jeff Boyce

One approach to handling this is to create an "order form". Create a new
form, add a field for selecting the query criterion (or multiple, if
appropriate), and add a command button that opens the report.

Modify your queries to "point" to the form for their criterion.

Add a control to your report that points to the form for its value.

Regards

Jeff Boyce
<Access MVP>
 
Top