Append Query every day at certain time automatically

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?
 
A

ant1983

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating an update query that uses multiple parameters 2
Append Query Issue 0
Append Query - Every 7 days 5
Append query in Access to SQL Server 2
How to delete query cache in Access 5
Access 2007 - append query only appending 0 rows??? 0
Access Access 2007 - append query only appending 0 rows??? 2
Append query bloat 4

Top