Querry Criteria

[Miasha]

I am trying to sort a querry by a field criteria. The field is a yes/no so
there is only the check box. I want the querry to display only the records
that are checked yes. I have tried using "yes" in the criteria box, but it's
not allowing it. Any suggestions?

 

[KARL DEWEY]

Use -1 (minus one) for Yes or True. Use 0 (zero) for No or False.

 

[Miasha]

I just tried your suggesion, but a window keeps coming up saying "data type
mismatch in criteria." What does this mean?

 

[KARL DEWEY]

Did you by chance use quotes around the -1? Just enter the minus sign and
the number one if your field is datatype Yes/No.

 

[Miasha]

Awesome. Thank you so much.

Did you by chance use quotes around the -1? Just enter the minus sign and
the number one if your field is datatype Yes/No.