Avoid entering multiple start/end dates

[unc2plo]

I have a macro that runs series of queries that pull information from several tables into a final report. I need to be able to run the report for various time periods (This week, last week, lst month, last quarter, etc).

Since I am pulling teh data from several sources I have to enter teh start/end dates separately for each query that the macro runs.
Is there a way to use a form or something that wil allow me to enter the start/end date only once - then have it fill in the rest of teh time?

I was thinking I could do a form that had only 1 set of date boxes and then have the remaining date boxes just "read" the original?

SDoes that make sense?

Thanks,
David

 

[Stormbringer]

You can use the Calendar function in a form with two text boxes, one for start date and one for end date. You will need to place the report names in a table or get them from a query and populate a list box with the report names. You can then use a command button to activate selection.