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

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

On Jul 7, 1:22*pm, HMK wrote:
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

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.