I have 3 tables with similar data. What's the best way to combine them into one table?
B Bill Apr 16, 2004 #1 I have 3 tables with similar data. What's the best way to combine them into one table?
D DDM Apr 16, 2004 #2 Bill, look up "Append Query" in Access help. Do an append query to add records from Table B to Table A, then one to add the records from Table C. DDM "DDM's Microsoft Office Tips and Tricks" www.ddmcomputing.com
Bill, look up "Append Query" in Access help. Do an append query to add records from Table B to Table A, then one to add the records from Table C. DDM "DDM's Microsoft Office Tips and Tricks" www.ddmcomputing.com