Filter values to include features within a specific max/min range

Question

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?

• FelixIP: I can see nothing in 2nd column <=65. No wonder selection is empty.
• Francis MacDonald: Sorry, I edited above so that it makes more sense now.
• Francis MacDonald: If you have an idea of how to select features as shown in the bar graph above I would love to hear it!
• Bera: (AgeMin <= 110) and (AgeMax >= 100)
• Francis MacDonald: 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......

Answer 1

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

Answer 2

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.

• Francis MacDonald: I tried that before as it seemed the most logical thing to do - that query returns no values
• Moh: @FrancisMacDonald Can you add a screenshot of a sample from your table to see the data how it looks like
• Moh: @FrancisMacDonald just press edit then press on the image icon
• Francis MacDonald: got it, posted above
• Francis MacDonald: 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?