Moving records from one table to another can be accomplished with the combination of an append query and a delete query.

Name: Moving records from one table to another can be accomplished with the combination of an append query and a delete query.
Brand: Quizplus
Rating: 4.9 (33 reviews)

Question

Quizplus · Accepted Answer

Yes, moving records from one table to another can be done by using an append query to add the records to the new table and then using a delete query to remove them from the original table.

Moving Records from One Table to Another Can Be Accomplished