How do I copy a record from one table to another table in Access

  • Thread starter Thread starter HMK
  • Start date Start date
H

HMK

I have a few different tables in the database with each table having
different fields - how do I move a record from one table to another table and
make sure that the field info gets put into the columns I need them to go
into - copy and pasting doesn't work as the info then gets pasted into the
wrong colums
 
I have a few different tables in the database with each table having
different fields - how do I move a record from one table to another tableand
make sure that the field info gets put into the columns I need them to go
into - copy and pasting doesn't work as the info then gets pasted into the
wrong colums
Click to expand...

Are the tables related? If so you could use an action query to append/
update or make a new table. In the QBE, you can specify what field
will receive the new information (in the case of different field
names).

If no relation exists, you could use a union query.
 
Back
Top