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.