Move a record from one .mdb to another

  • Thread starter Thread starter T. Wise
  • Start date Start date
T

T. Wise

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?
 
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?
Click to expand...

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.
 
Back
Top