Query criteria for Yes/No table

[jcaptchaos2]

I have a table that has part number, part name and a Yes/No field that the person puts a check mark in if they do not want it to come up in another query. I have a query that has three tables joined by an item number, what do I put in the criteria field for the Yes/No part of it. It does not seem to matter if I put yes or no it still pulls both with the check mark and without the check mark.

 

[giacomo]

the criteria should be Yes or No (no quotes) depending on which you want to return. If you tried that already please post your SQL so we can have a look at it.

hth,
Giacomo

 

[jcaptchaos2]

I ended up having to query the table and then add the query for the no's to the query I was using and now it works.