I have one record in one file that I want to delete from the first file and
move into the 2nd. How do I do this?
As long as the tables have the same structure, you can use an Append
query to add the record to the other database, then use a separate
Delete query to remove the record from this database.
In query design view, click on Query + Append
The wizard will walk you through it.
Then create the delete query the same way:
Click on Query + Delete
Make sure the criteria is identical in both queries.
