look for macro for delete

[xiaodan86]

how to use macro with a list of RunSQL statements in it that delete
records and apend records to a new table?

I have a database to save records for tool performance everyday.
how i can create a macro that make a copy of the current access file
to a new location and delete the records in the table for past 3
months?

 

[Allen Browne]

If you have created a Delete query and an Append query, use RunSQL in your
macro to run them.

You may find it safer to do it in code, where you can get feedback about
whether the queries completed successfully or not. Details in:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html