Finding records in one DB that are not in another

  • Thread starter Thread starter Cindy
  • Start date Start date
C

Cindy

I have two tables, a product master file and a price list which is a subset
of the product master file. I need to find all records that are in the
product master file but not in the price list. The part number(MPN) is key
in both tables. I tried a query where MPN is "not like MPN in price list
table" but got no results. I also tried the right and left join but they
seem inclusive rather than exclusive. I am just learning Access.

Thanks
 
Cindy

A bit of terminology to begin ... when you talk about more than one "DB" in
Access, you are talking about more than one Access.mdb file (i.e.,
"databases").

Your description leads me to believe you have two tables, not two "DB"s.

If you click on the <New> button's dropdown symbol, you can pick creating a
new query. When you start this (wizard) you are prompted for which kind of
query. I suspect you want an "unmatched" query. Follow the wizard's
instructions to a "not in" query.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thanks Jeff. You're right, I meant tables, not databases. The unmatched
query worked great!
Cindy
 
Back
Top