query help! (1 Viewer)

TimjHebert

Registered User.
Local time
Today, 16:41
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?
 

Mile-O

Back once again...
Local time
Today, 22:41
Joined
Dec 10, 2002
Messages
11,316
By using an APPEND query and a DELETE query.
 

Users who are viewing this thread

Top Bottom