K
Kelly
I have been asked to clean up a very complicated Access database. I have two
tables, with the identical headings, different information.
--Table1 is all the customers in one part of town
--Table2 is all the customers in another part of town
(why, they did this, Im not sure)
Each table is very large and I need to combine them or merge them togeher,
either merge table2 into table1
or
take table1 and table2 and create a table3.
I was able to create a union query, but not sure how to then create a 'mater
table' from that query. I need to further create at least two junction
tables from this 'master table' and want to make the database as clean as
possible. I thought about just cut and pasting the info...
Anyone have any ideas
tables, with the identical headings, different information.
--Table1 is all the customers in one part of town
--Table2 is all the customers in another part of town
(why, they did this, Im not sure)
Each table is very large and I need to combine them or merge them togeher,
either merge table2 into table1
or
take table1 and table2 and create a table3.
I was able to create a union query, but not sure how to then create a 'mater
table' from that query. I need to further create at least two junction
tables from this 'master table' and want to make the database as clean as
possible. I thought about just cut and pasting the info...
Anyone have any ideas