unmatched on multiple fields

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

Guest

Hi all. I am trying to find records that are in one table that are not in the
other. I tired to use an Unmatched query but it only allows for one field
from each table to be compared and I need to compare three.
 
TC said:
Hi all. I am trying to find records that are in one table that are not in the
other. I tired to use an Unmatched query but it only allows for one field
from each table to be compared and I need to compare three.
Click to expand...


Join the tables on all three fields and make sure all three
join lines have three join line arrows pointed the same way.

If that's not sufficient to get you going, please post an
explanation of the two table's matching fields and the
primary key fields.
 
Thank you.

Marshall Barton said:
Join the tables on all three fields and make sure all three
join lines have three join line arrows pointed the same way.

If that's not sufficient to get you going, please post an
explanation of the two table's matching fields and the
primary key fields.
Click to expand...
 
Back
Top