How do I compare two tables in access so I can see the difference

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables with simular data in both. I need to compare the two
tables to see what's different in both.
 
Check the query wizard that lets you chose unmatched. Have to have two
so to get both sides of test.

Then for those that match, append both to a common table with an id
that tells which they are from and then use wizard for duplicates.

or link two together by matching key and create a form that lets you
compare fields or add logic to that to compare them to only show those
that are different. etc.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing two tables 6
Excel Comparing two columns 1
Compare Two tables in MS Access. 1
Tracking differences between tables 2
Comparing two exact .mdb files 6
Access Compare records in same access table 0
How Can I compare information in Access? 4
Comparing Data in TABLES 3

Back
Top