Monthly Report

[Guest]

I have a series of reports I run monthly, around the first of every month...
I want to set it so that when the report is selected, a small form opens
asking for the month the report is needed for..... Even if it could just
prompt for the date range that would work... Thought I knew how, but have not
had any luck....
Currently I go into each Query and Filter for the Date range, but have
about 10 seperate queries. Would like to make this easier for others to
choose & print the reports by date....
Thanks For any Help...
Aaron

 

[Brendan Reynolds]

There are some examples of this sort of thing in the 'Northwind' sample
database that comes with Access. Look at the 'Employee Sales by Country'
report for a simple example that uses the built-in parameter prompt. See the
Sales by Year report for a more sophisticated example using a custom form to
gather the parameter values.

 

[Guest]

Thanks, Didn't even think of that.......
Having a sample to look at should be all I need,

Thanks for the Suggestion....

aaron