If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
How do I copy a record from one table to another table in Access
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. |
Thread Tools | |
Display Modes | |
|
|