Automate Append Query

D

Dan

I have an append query that places all the vehcile in our fleet into a
Monthly Mileage database. Is there any way to have this append query to
automatically run on the 20th of every month without me having to manually
run the query to do this?
 
C

Carl Rapson

The only way I know of to do that is to create a macro to run the query and
then execute the macro from the Windows Scheduled Tasks application. You can
run a macro from the Access command line; see the on-line Help for details.

Carl Rapson
 
Top