Query quandry

G

gail

Is there anyone who can explain how to query 2 separate
tables for matching AND unmatching data? I have to compare
2 tables looking for matched and unmatched values in 2
different columns.
 
E

es

Use the wizzard to help you create this. It will only
allow you to choose one field to compare but as the
wizzard ends there is a check box for if you want to
modifiy the query. Check this then you can duplicate the
code for the other field to compare.
 

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

Matched Query 2
Unmatch query? 8
Comparing two tables in Access to look for discrepancies 0
Exclusion Query- MS Access 2007 2
Help! Unmatched Data Query 1
Query that will look for duplicate in two tables. 3
Exact match query 4
Query without wizard 3

Top