0

I want to select from the Attribute table all items with step by 2 (select one item, I don't select the next one, etc). How can I do that? I'm using ArcMap 10.2.2.

2

This expression shows how to select every other record. You have to run it on a short or long integer field that is incremented consecutively. If you add or delete a record you'll have to re-increment the ID field before running mod query again.

MOD(OBJECTID, 2) = 0

Selects the second record and ever other after that

MOD(OBJECTID, 2) = 1

Select the first record and ever other after that

  • 1
    That would only work with consecutive objectid's wouldn't it? A user could have deleted oid's 2, 4, 6, etc. – Berend Nov 9 '16 at 15:23
  • It didn't work... any other thoughts? – NikosGr Nov 9 '16 at 16:09
  • Create another ID field (short or long integer) and increment from 1....x and try it on that. If you delete or add a feature you'll have to re-increment the ID field before running the mod query. – artwork21 Nov 9 '16 at 16:11
  • 1
    @NikosGr, what about it didn't work? What results/error message did you get? – Tom Nov 9 '16 at 16:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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