how do i set up access to automatically run reports

[Guest]

i Need to set up a method of running different reports based on time periods.
I need to run reports both weekly and monthly. I am currently having to put
these reports together every time. With the same fields being used. Is there
a way of creating a button that will run the correct reports for that week.

 

[Duane Hookom]

You can keep a table with the names of your reports and their frequency.
Create a form that selects the "frequency" value from a combo box and
creates a record set of the reports that need to be run based on the
frequency. The code can loop through the recordset and print each report as
required.