G Guest Apr 24, 2006 #1 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
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
G Guest Apr 24, 2006 #2 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.
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.
