yes/no datatype

  • Thread starter Thread starter stefan
  • Start date Start date
S

stefan

I have check box field formatted as yes/no in the table.

I am trying to filter my query to only fields were the box
is checked.

I have tried the value 1 and the value "Yes" neither work.

What criteria do I use to return boxes that are checked?

Thanks in advance
 
I have check box field formatted as yes/no in the table.

I am trying to filter my query to only fields were the box
is checked.

I have tried the value 1 and the value "Yes" neither work.

What criteria do I use to return boxes that are checked?

Thanks in advance
Click to expand...

Use either
-1 (which is the check box Yes value, not 1) or
Yes (without the quotes).
 
Back
Top