Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Archiving
- Thread starter asmall
- Start date
just create two queries. One is a insert query that inserts data from your current table to your archive table, and the other an delete query that deletes data from your current table. Next create a macro that calls the insert query first and then the delete query.
All Done.
All Done.
asmall,
Read this entire thread it will help you: thread702-661273
HAVE A BLESSED THANKSGIVING!!!!!
Jerome Benton
JERPAT Web Designs
GOD Is Good All The Time!!!
Read this entire thread it will help you: thread702-661273
HAVE A BLESSED THANKSGIVING!!!!!
Jerome Benton
JERPAT Web Designs
GOD Is Good All The Time!!!
- Status