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?

"ruralguy via AccessMonster.com" wrote:

> YES but your db would need to be running in order for that to work. You could
> also create a scheduler task to run your db at a certain time and pass it a
> command line parameter.
>
> ant1983 wrote:
> >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?
>
> --
> RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
> Please post back to this forum so all may benefit.
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...dules/201001/1
>
> .
>