ACCESS 2003 QUERIES

[Rae03]

If I have 3 tables of UPC numbers some will match each other and some will not,how do I take these 3 tables and match and unmatch to create one table of UPC numbers without duplicating each other?

 

[DBAMJA]

Decide which table it is that you want to be your master table. Once you have done that, create an unmatched query from the master table to one of your other two tables (Use the wizard to do this). Once the query is created, turn it into an append query and append the data to the master table. Repeat this with the other table and you will be all set.

[flush]

DBAMJA

It is said that God will give you no more than you can handle. I just wish God didn't have so much faith in me.

 

[Rae03]

Thank you,that worked great.