Monthly Append Query automated

mcadle

Registered User.
Local time
Today, 13:51
Joined
Jul 16, 2004
Messages
84
I am attempting to automate a query. I have an append query that I currently manually run. I want it to run one time at the beginning of the month. I have been trying to figure out how though. I think that when on DB open it needs to check the last time it ran. If it was last month, then run it again otherwise don't do anything. Does anybody have any ideas? or has anybody seen anything like this before? Thanks in advance.
 
you can create an autoexec macro that does what you need and then setup a scheduled event in windows to open it up. ?? Just a thought - there's probably a better way...
 
True..but this is a networked database. The front end resides on the site server. The good thing is, that 100% guaranteed this DB will be opened at least 6 times a day. I was thinking autoexec though. Thanks for the input.
 

Users who are viewing this thread

Back
Top Bottom