Automate Append Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top