I have 2 tables with identical fields. What is the best way to combine the tables into on big table?
G ganderson Aug 16, 2003 #1 I have 2 tables with identical fields. What is the best way to combine the tables into on big table?
K Kevin3NF Aug 16, 2003 #2 Use an Append query to append the records of one to the other. This will only work if your primary keys do not duplicate. Post back if you need instructions...
Use an Append query to append the records of one to the other. This will only work if your primary keys do not duplicate. Post back if you need instructions...
