specifying search criteria

R

Ryan Young

I'm trying to specify some search criteria in a query in which I want to
search based on my Complete field being checked or unchecked (to basically
say yes or no). What string do I need to enter in the Complete field's
search criteria to show complete (checked) entries?
 
K

KARL DEWEY

If you are talking about a Yes/No field then zero and minus one are the
values. Minus one ( -1) equals yes.
 
V

Van T. Dinh

Set the criteria to True (or -1 which is the same thing) if you want to
select checked or False (0) if you want to select unchecked for the Boolean
Field.
 
Top