Query quandry

  • Thread starter Thread starter gail
  • Start date Start date
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.
 
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.
 
Back
Top