R rokjock Sep 20, 2004 #1 I would like to combine two of my tables but cannot figure out how(they have very similiar fields). Thanks in advance for any help!!
I would like to combine two of my tables but cannot figure out how(they have very similiar fields). Thanks in advance for any help!!
A Allen Browne Sep 20, 2004 #2 Assuming you want the records from Table2 merged into Table1: 1. Create a query into Table2. 2. Change it to an Append query (Append on Query menu). Access will ask which table to append to, and add a new row to the grid. 3. Use the Append To row to map the fields. (They will map automatically if they have the same names). 4. Run the query.
Assuming you want the records from Table2 merged into Table1: 1. Create a query into Table2. 2. Change it to an Append query (Append on Query menu). Access will ask which table to append to, and add a new row to the grid. 3. Use the Append To row to map the fields. (They will map automatically if they have the same names). 4. Run the query.
