I have been trying by best to create a definition query which would select a group of municipalities from among the many in my state. I have tried commands of all sorts of variations from "Name"='Chatham'AND 'Chester' AND 'Far Hills'..... to "Name"=('Chatham', 'Chester', 'Far Hills... and so on but I keep getting an error when I try to validate.


3 Answers 3


Building a query expression. Check the Combining Expressions sub-heading to see how to use the AND/OR operators correctly.

For your example you should implement "IN":

"Name" IN ('Chatham','Chester')

  • Great! For me single quote was the gotcha.
    – danwild
    Commented Jun 13, 2018 at 3:11

Use "Name" IN ('Chatham','Chester Falls'...) Separate each with a comma and end with a closed parenthesis.


I would think OR rather than AND

  • 4
    @Katie, in your example, you also left out the fieldname in front of each query attribute. If you wanted to use this mething, you would need to include the fieldname in front of each query attribute: "Name"='Chatham' OR "Name"='Chester' OR "Name"='Far Hills'. This is slow and tedious, so using the "IN" operator is much more efficient. Commented Jun 13, 2011 at 23:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.