English

How To: Select multiple values with the Select By Attributes tool

Summary

Instructions provided show how to select multiple values within a field using the Select By Attributes tool.

Procedure

Using the word 'IN' allows for multiple values to be selected without adding the field name each time.

  1. Open the attribute table of the layer, select the Options button on the lower right, and click Select By Attributes.
  2. Double-click the field that contains the desired values to populate the dialog box below. Add a space after the field name and type in the word 'IN' (no quotes).
  3. Select the parentheses icon above.
    [O-Image] selection2
  4. Inside the parentheses select or type the desired values. Separate each value with a comma.
    [O-Image] selection
    Note:
    If the field is a text field, be sure to apply single quotes around each value.

  5. Click Apply.

Related Information