Matching two fields in two tables

[twallstr]

In a database I have two tables, one is linked to an excel sheet (our customers order) and the other is created via a "make-table query" from our business system.

In both tables I have the customers part numbers and neither contain a primary key.

What I need to do is compare the part numbers in both tables to find if a part number is present in the order but not in our business system.

I just cannot figure out how to do this.

Any ideas are greatly appreciated

/twallstr

 

[TanisAgain]

Create a new query with the wizard and choose 'Find unmatched query wizard'

 

[twallstr]

Excellent!

Thank you!