HOW TO

Query even or odd values in a field stored in a File or Personal Geodatabase Feature Class

Last Published: April 25, 2020

Summary

Instructions provided describe how to query even or odd values in a field.

Procedure

The expression is set to 0 for querying even records and 1 for querying odd records.

  • For personal geodatabase tables, use the following:

    [field] MOD 2 = 0
    [field] MOD 2 = 1

  • For database file format (DBF) or file geodatabase tables, use the following:

    MOD( "field" ,2) = 0
    MOD( "field" ,2) = 1

Article ID:000009549

Software:
  • ArcMap 8 x
  • ArcMap 9 x

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options