Querry Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
I just tried your suggesion, but a window keeps coming up saying "data type
mismatch in criteria." What does this mean?
 
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.
 
Awesome. Thank you so much.

KARL DEWEY said:
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.
Click to expand...
 
Back
Top