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