yes/no datatype

[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

 

[Ken Snell]

Use True or -1.

 

[fredg]

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

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