Queries - Help MS ACCESS 2013

[joemills62]

I have a customer database and a orders database link clientid



I want a list of customers who do not have an entry in the product table the contains a certain product code

My criteara is NOT "6" (6 being the product code)

The query works, but it shows duplicate customer entries because they have other products in the table

I just want it to show customers who doe not have this product code in the orders table

any ideas, i have tried all join configs but still no luck

[pbaldy]

First create a query that finds all the customers that do have that product code, then use the unmatched query wizard to compare that query to the customer table.