MATCH DATA IN SEVERAL DIFFERENT FIELDS FROM TWO TABLES

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

Guest

I have two tables with about 12 different fields. I need to create a query
that will match table 1 to table 2. The fields that need to be matched are
business id in table 1 to customer id in table 2, product ( there could be 6
different products ( this field is in both tables)) and invoice numbers (
which is in both tables also). I need to find which data is not matching
based on these 3 fields. Can anyone help me?
 
sabse,

PLEASE DON'T YELL. ;-)

Did you try the Find Unmatched Query Wizard?

HTH,
Josh
 

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

How to Populate Data from a table to another 0
Update Data in one table based on matching field in another table 4
Updating tables when you input new data 0
Making fields same between tables 1
Combining two tables with no matching field name 8
Linking two tables 1
Nested query problem 6
Comparing data between 2 tables 5

Back
Top