Running similar reports based on Parameter Queries

[Tamrak]

Hello all,

I constructed 10 reports based on 10 different queries. However, all of my parameters will allow the users to select the start and end dates.

In the "mydate" field, I used Between[start date:]and[end date:]. "Mydate" is the common fields in all 10 reports.

The macros will prompt my boss 20 times to input the start and end dates, if she wants to run these 10 reports.

Since these 10 reports have similar parameter queries inputs and using the same field name, mydate, is there any easier way to do it?

I wish I can do the following:

1. Allow only 2 prompts for the parameters (start and end).
2. Report 1 to Report 10 will run without anymore prompt.


Thank you for your reply.

 

[JoeMiller]

Make a form, put text boxes for the dates. Change the queries to reference the corresponding text boxes on the form. Now the boxx fills in the fields on the form, pushes a button, and you can open up all 10 reports in succession.

Between [Forms]![MyFormName]![MyStartDate] and [Forms]![MyFormName]![MyEndDate]

That's the criteria you'll use. And you'll line up the open report statements like this in the OnClick event of a command button.

DoCmd.OpenReport "MyReportName1"
DoCmd.OpenReport "MyReportName2"
DoCmd.OpenReport "MyReportName3"
etc...

Hope that helps!
Joe Miller
joe.miller@flotech.net