Does not equal Join (access 2003)

  • Thread starter Thread starter PerryK
  • Start date Start date
P

PerryK

I have 2 tables with data that includes "Part Numbers" in both.

I want to create a Query to list all of the data in the first table, but not
for the "Part Numbers" that are in the second table.


How do I create/format the "Join" for does not equal the "Part Numbers" from
the second table?

Thanks
 
Perry

Start the query wizard, select "unmatched".

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff,

Thanks for the suggestion.

Sometimes we just need to open our eyes and have another cup of coffee!!!!!!!
 
Back
Top