results of unmatched items

results of unmatched items

Post by jeff » Fri, 16 Jan 2004 02:10:09


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.
 
 
 

results of unmatched items

Post by John Vinso » Fri, 16 Jan 2004 07:12:38

On Wed, 14 Jan 2004 09:10:09 -0800, "jeff" < XXXX@XXXXX.COM >



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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://www.yqcomputer.com/