I am a new member here and have looked around to find an answer to my question but I guess I don't know enough about Access to even know where to look. I hope someone can help me!

After running my queries, I have to print about 50 reports. I highlight each report individually and type in the beginning date...example, June 27, 2005. Then I type in the ending date...example, July 1, 2005. Then it askes for the title and I type June 27, 2005 thru July 1, 2005. It will not allow me to highlight each report at the same time. For instance, I can't hold down the shift key and highlight multiple reports. Its so time consuming to do this. I am a new user of Access and the people at work that trained me have told me there is no better or easier way to do this. If anyone has a suggestion I would really appreciate it!!!

Thanks, Sue

>>> After running my queries <<<
What do these queries do?

>>> type in the beginning date...example, June 27, 2005. Then I type in the ending date...example, July 1, 2005. <<<
What defines the Date range?

>>> askes for the title and I type June 27, 2005 thru July 1, 2005. <<<
Is the title always related to the date range?

Is the db an *.mdb .....

>>> After running my queries <<<
What do these queries do?

>>> type in the beginning date...example, June 27, 2005. Then I type in the ending date...example, July 1, 2005. <<<
What defines the Date range?

>>> askes for the title and I type June 27, 2005 thru July 1, 2005. <<<
Is the title always related to the date range?

Is the db an *.mdb .....

Thanks for the quick reply. I will try to explain, but again I am very new to Access. I go to Access and and enter information from the previous week. After that I have to run weekly, monthly and yearly queries so that the info I typed into Access can be printed out. The queries contain all the information that I added into Access for the previous week. The date range is always Monday thru Friday and the title is always related to that date range. Again, I first have to put in the beginning date, then the ending date, then the title. Does that help?

>>> The queries contain all the information that I added into Access for the previous week<<<
More info on the queries you run please!

And again, is the db an *.mdb .....?

You can create a form to capture the parameters and run the reports. In the form's Open event you can put an initial value in each field based on the current date. Then after the form opens, you can override the the suggested value by typing in the field. This will minimize your data entry and yet give you the flexibility of re-running previous reports if necessary. The form needs a button to run the reports. Let the wizard build the code to run the first report. When it is done, you go to the button's click event and add as many DoCmd.OpenReport lines as necessary following the first.

You will need to change the reports' RecordSource queries so that instead of prompting, they get their data from the new form.
Where SomeDate Between Forms!frmYourForm!Date1 and Forms!frmYourForm!Date2;

Modify the queries so that they calculate the title field from the two date fields.