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!!!!!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Partial match Join query 3
Not Equal To 1
Delete query with joined tables 0
Join Properties 1
Finding possible matches 8
Help with OUTER JOIN 2
update queries 4
Many to Many/lnktable/query 2

Back
Top