query help!

TimjHebert

Registered User.
Local time
Today, 00:34
Joined
Dec 12, 2004
Messages
40
i have set up a rental program with several tables. i would like to make duplicate tables to copy the data to and use them as a history table. after the data has been copied to the tables i would then like to delete the records in the main data base. how can this be done?
 
By using an APPEND query and a DELETE query.
 

Users who are viewing this thread

Back
Top Bottom