Knowledge Base - Technical Articles


Technical Article   HowTo:  Select multiple values with the Select By Attributes tool

Article ID: 32024
Software:  ArcGIS - ArcEditor 9.0, 9.1, 9.2, 9.3, 9.3.1 ArcGIS - ArcInfo 9.0, 9.1, 9.2, 9.3, 9.3.1 ArcGIS - ArcView 9.0, 9.1, 9.2, 9.3, 9.3.1
Platforms:  Windows 2000, XP

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.-show me-

    [O-Image] selection2
  4. Inside the parentheses select or type the desired values. Separate each value with a comma.-show me-

    [O-Image] selection


     If the field is a text field, be sure to apply single quotes around each value.

  5. Click Apply.

Related Information


Created: 10/30/2006
Last Modified: 5/3/2011

Article Rating: (2)
If you would like to post a comment, please login

Comments

By eesaali - 05/10/2013 10:24 AM

I would like to see a new article that discusses the topic outlined below.

I would like to select multiple values with the "Select By Attributes tool" using a list of values say, from an excel spreadsheet. Is this possible or there a limit to the number of values in the query?

Rating:

By Panaro60 - 11/15/2012 8:45 AM

Other - See details below.

Why is this description not INCLUDED in the help section in ArcMap when you click on HELP? Why did I have to look for this information on the web, especially since this is such a common task????

Rating: