Append Query every day at certain time automatically

  • Thread starter Thread starter ant1983
  • Start date Start date
A

ant1983

Hi,

So i have a query qryStats. Basicaly i want to be able to see how the stats
have changed over a period so i was thinking of turning that simple query
into an Append Query so that it just add the results to a table tblStats.

I tested it and it works great so i can design reports and the result is
exactly what i want.

Problem is im going to forget to run the query each day. What are my
options? Can i write code of some kind that runs the append query each day
at, lets say 16:00?
 
Yeah the db would be open so thats not a problem. Alternatively, if i open
or close the db and it prmpted me; that could work to.

Do you know how to do it as im a novice?
 
Back
Top