results of unmatched items

  • Thread starter Thread starter jeff
  • Start date Start date
J

jeff

I have office XP. I'm trying to extract records from 1
table that are not an exact match of any record on a 2nd
table. there are 3 fields that are being compared. can
anyone help me find a way to get this information.
 
I have office XP. I'm trying to extract records from 1
table that are not an exact match of any record on a 2nd
table. there are 3 fields that are being compared. can
anyone help me find a way to get this information.
Click to expand...

There's an Unmatched Query Wizard; create a new query and select the
wizard. If it chokes on the three fields post back, it's not that hard
to create a "frustrated outer join" query to do it - just let us know
the table and fieldnames so we can give a real example.
 
Back
Top