0

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 '18 at 10:31
  • Sorry, I edited above so that it makes more sense now. – Francis MacDonald May 26 '18 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! – Francis MacDonald May 26 '18 at 19:29
  • (AgeMin <= 110) and (AgeMax >= 100) – BERA May 26 '18 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...... – Francis MacDonald May 26 '18 at 19:37
3

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

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.

  • I tried that before as it seemed the most logical thing to do - that query returns no values – Francis MacDonald May 25 '18 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 '18 at 23:23
  • @FrancisMacDonald just press edit then press on the image icon – Moh May 25 '18 at 23:39
  • got it, posted above – Francis MacDonald May 25 '18 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? – Francis MacDonald May 26 '18 at 18:26

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.