I want to run a report at set times, ususally at month end after hours. is
there a way of setting this up in Access.
Yes. You can launch Access from the Windows Scheduler, using a command line
such as
"C:\Program Files\yadda\msaccess.exe" "E:\path\yourdata.mdb" /x "runreport"
You would have a macro named runreport; the /x switch will execute that macro.
Be sure to have a Quit line at the end of the macro. Adjust the file and path
names of course.