Build an query that will only select "yes" to an question

R

Roger

I want to build a query that will only pick the client that answer yes to a
field. How do I do this.

thanks
Roger
 
J

Jerry Whittle

Depends on the type of field where Yes is stored.

If it's a Text field, put "yes" in the criteria under that field in the
query. Include the double quotes.

If it's a Yes/No field (A.K.A. boolean field) put in -1 or Yes (without the
quotation marks). In Yes/No fields -1 is the same as Yes and 0 is No.
 
Top