I have a table of values that have a MIN and MAX integer value, i.e.

enter image description here

I would like to select all values that range from Age_MIN >= 105 to Age_MAX <= 110. There are features in the table that would fall into that range, but I'm not sure how to query them.

When I do a definition query with Age_MIN >= 105 to Age_MAX <= 110 I get this result:

enter image description here

As a visual representation of what I would like to do, please see below image:
enter image description here

Here, the features (horizontal bars) in blue would be selected, and the yellow bars would be unselected as they don't fall within the range of 100 to 110.

Any ideas?

  • I can see nothing in 2nd column <=65. No wonder selection is empty.
    – FelixIP
    May 26, 2018 at 10:31
  • Sorry, I edited above so that it makes more sense now. May 26, 2018 at 18:29
  • If you have an idea of how to select features as shown in the bar graph above I would love to hear it! May 26, 2018 at 19:29
  • (AgeMin <= 110) and (AgeMax >= 100)
    – BERA
    May 26, 2018 at 19:33
  • Same, no features selected. I know this sounds like a very simple task, and I've been telling myself the same thing, but I really don't know how to do this...... May 26, 2018 at 19:37

2 Answers 2


To select the age ranges that in some way overlap 100-110 the query should be:

(AgeMin <= 110) AND (AgeMax >=100)

enter image description here


Selection >> Select by attribute

"Age_MIN" >= 60 AND "Age_MAX" <= 110

Update: From your field values in the picture attached in your question and as FelixIP mentioned that there are no values <=65 so in this case you will get no records.

  • I tried that before as it seemed the most logical thing to do - that query returns no values May 25, 2018 at 23:18
  • @FrancisMacDonald Can you add a screenshot of a sample from your table to see the data how it looks like
    – Moh
    May 25, 2018 at 23:23
  • @FrancisMacDonald just press edit then press on the image icon
    – Moh
    May 25, 2018 at 23:39
  • got it, posted above May 25, 2018 at 23:40
  • ok sorry, lets make it Age_MIN >= 105, and Age_MAX <= 110. There are values that fall within the range in the table. How would I select those? May 26, 2018 at 18:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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