for my database i need to print both anual and quarterly reports, is it possible for this to happen automatically, or will i have to click a button? assignment due in tomorrow so any help gratfully recieved!

Cheers

The simplest way is to use Windows scheduler. Create a macro to run the year end report and another to run the quarter end report. For the year end date create a .bat file that opens your access database and runs the yearend macro. Do the same for the quarter end reports except run the quarter end macro.

You can do this in code within the database but it requires that you open the database in order to run. If you forget to open the database at the appropriate time, the reports won't run.

Thanks a lot, all is almost good in my database now!

cheers! :) :) :) :)