Unmatched records for multiple field match

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

Guest

I'm comparing 2 tables, but it takes 3 fields to generate a match. I need to
know which records in the 2nd table did not match records in the first. What
would be the easiest way to do so? Generating the match looks like it can be
done by a click/drag join in the query itself for the 3 fields.
 
-- Put both tables into the query
-- Drag from your first matching field in table2 to the corresponding field
in table1
-- Double-click on the join line and select ALL in table 2 ... and only in
Table1
-- Add table1.corresponding field to the grid
-- Set its criteria to Is Null
---- Repeat above 4 steps for the other two matching fields
-- Add fields in Table2 that you want to see
 
Back
Top