Excluding a list of items in a query

[John liem]

I have a Tbl_Product (4000 items) and want to run a query which exclude a list of products (223 items), I put the list as a table Tbl_Excl.
How can I do this in an easy way?
I am using Access 2000 and quite familiar with SQL. Thanks in advance, John

 

[pbaldy]

Fairly simple, unless I've misunderstood:

SELECT ItemField FROM Tbl_Product
WHERE ItemField NOT IN (SELECT ItemField FROM Tbl_Excl)

 

[John liem]

Hi Paul, Hi Pat,

Thanks for your great help .. it is easy (if you know it).
John.