still learning but here's my question. is there a way to have my database see that its a new month and then run a report that could be automatically emailed?
that's were I'm learning and scratching my head. what if the 1st of the month falls on Sunday? we are using outlook. I have it auto emailing some other stuff when they push the "end shift" button. I was curious if we could get it to recognize the first Monday of the month and then run the report? would this be a macro?
sorry but that's above my head. how can that be used to find the first Monday of each month? what if I created a table that held all the 12 dates of the year that I wanted the database to run this particular report? how would I have it compare the current date to the dates in the table and decide if "true" then continue? that may be a easier path. once a year I could look at a calendar and type in the 12 dates that I want it to run.