Yes/No Queries

[Don Hicks]

Hello,

I have an Access '97 database with a table containing a Yes/No checkbox
field.

When I query the records in the table with no "Yes/No" criteria specified, I
get 33 records returned.

When I query the table, specifying "Yes" as a criterion, I get 11 records
returned. (And, yes, there ARE 11 records checked "Yes.")

When I query the table, specifying "No" as a criterion, I get 0 records
returned--shouldn't I be getting 22 records, instead? (Specifically, the 22
records that haven't been checked "Yes?")

Can anybody give me a hint what to ask for as a criterion in the query, so I
get all the records that haven't yet been checked "Yes?"

Thanks,
Don Hicks
Portland, OR

 

[Rick B]

Try true/false or -1 and 0

Rick B


Hello,

I have an Access '97 database with a table containing a Yes/No checkbox
field.

When I query the records in the table with no "Yes/No" criteria specified, I
get 33 records returned.

When I query the table, specifying "Yes" as a criterion, I get 11 records
returned. (And, yes, there ARE 11 records checked "Yes.")

When I query the table, specifying "No" as a criterion, I get 0 records
returned--shouldn't I be getting 22 records, instead? (Specifically, the 22
records that haven't been checked "Yes?")

Can anybody give me a hint what to ask for as a criterion in the query, so I
get all the records that haven't yet been checked "Yes?"

Thanks,
Don Hicks
Portland, OR

 

[rey]

When creating a criteria to filter out a "Yes/No" field, don't put quotes on the Yes or No. This is not a Text type field.