YES /NO Query

R

Rpettis31

I have a query that I want to list of all records that do not have a yes it
is the yes/no data type and I am not familiar how you query from this data
type?
 
C

Clifford Bass

Hi,

Pretty simple. While in the query designer, add the yes/no field to
the list of fields in the grid. Then in the Criteria line underneath it
enter any one of: No, False or 0.

Clifford Bass
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Evaluate Yes/No Field Based on User Input 7
Delete Query: Could not delete from specified tables 0
update a combo box using an update query 3
Count Yes/No with Criteria 2
IIF Function Within A Query 6
Yes/No Data Type 2
Access Dcount (multiple criteria) 3
Combine Duplicates in Query 0

Top