Query in msaccess
I have a query that returns a list of product numbers.
I have a second query that has a list of product numbers that I want to exclude from the first queries list.
how do I do this?
I have a second query that has a list of product numbers that I want to exclude from the first queries list.
how do I do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Luke Chung
You are looking for a Not-In Query. Here's a paper I wrote with examples of how to do it: http://www.fmsinc.com/MicrosoftAccess/query/outer-join/index.html