Automatically Run Access 2007 Report

[cambonner]

I'm rather new to Access, so forgive my inexperience. I've just created a database for a food pantry to keep track of data on clients, their families and food deliveries. We need to produce monthly reports of activity as a requirement of our grant. I've designed the report and it works great. However, I would like to have the report run and be saved automatically on the first instance of the db being opened in a new month. This is important since there are many (inexperienced) users of the db, and we can't rely on them to run and save the report as needed. By the time the db manager gets to the food pantry, perhaps on the 5th of the month, the data in the client table might have changed from visits that occur on say the 1st to the 4th, so running the report on the 5th will yield invalid results for the previous month.
Any help with this problem much appreciated.
Cameron

 

[spikepl]

Your data structure most likely needs some work. Your report's content should in no way depend on what day/time you run it. Data should be tagged with datetime so that you can extract what is needed for any reporting period you'd wish at any time.

Upload a screenshot of your relations, with all tables expanded such that all field names are visible.