Unanswered: How can I auto run a query at a certain time of the day?
I recently inherited a database that is in need of modification.
Access is not my forte'
Here's the scoop...
(Any interjections will be more than welcome)
There are 13 tables I need to check information in daily.
Each table has an auto-incrementing "id" field.
I think I will need to use that field to pull the most recently entered record (highest number in "id" field of each table.)
I will need to , in each table, check one or more fields to see if the data within them falls within a range of parameters (mostly greater than and less than), then if the data falls out of the parameters I need it to generate a report with the contents of the field and a warning message that corrective action may be needed. This will need to be sent out to one or more email recipients.
Is there any way that I can set up some kind of auto-task to run this daily?
What is the best route to get this started?
Any design tips will be greatly welcomed...