Access 2003, comparing fields between 2 tables

A

Aist

Hi - I am trying to return non-duplicate fields from 2 tables. tblParts is a
Parts list with specific partnumbers and tblGDSOUT is a table created from a
txt file which is a series of barcode reader scans. I want to compare the 2
partsnumber fields and return any un matched values in order to capture out
of date barcode if you catch my drift!!?? Have treid several combinations of
queries and joins and not equal to's, but nothing seems to work!! Can anyone
help?
 
J

Jeff Boyce

Open Access.

Select the query wizard.

Select the "unmatched" query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top