Greater than, Less than (1 Viewer)

[kitty77]

What is the best way to state this...

If [field1] is less than 20 and greater than 22 then...

Thanks.

 

[theDBguy]

Hi. But that seems impossible. I don't know of any value that is both below 20 and at the same time above 22.

 

[vba_php]

If [field1] is less than 20 and greater than 22 then...

guy is right, Kitty. I think you're trying to ask something else, because you're smart enough to know what is possible and what is not possible. maybe uploading what you've got would help us help you.

 

[The_Doc_Man]

IF NOT ( [Field1] BETWEEN 20 AND 22 ) THEN...

If you are looking for "outliers" (things outside a preferred range), the above might be one way to do it.

 

[jdraw]

Kitty,
Please review your requirement.

 

[kitty77]

Yes, stated that wrong. if the number is outside the range of 20-22 then...
Less than 20 or greater than 22

 

[The_Doc_Man]

Guys, looking for outliers is common practice. My wife is ALWAYS giving me outlier tasks.

IF NOT ( Thermostat BETWEEN 70 AND 72 ) THEN MakeItSo

 

[vba_php]

Guys, looking for outliers is common practice. My wife is ALWAYS giving me outlier tasks.

IF NOT ( Thermostat BETWEEN 70 AND 72 ) THEN MakeItSo

classic richard. LOL. mr. fix it, like so many women want.

 

[vba_php]

Yes, stated that wrong. if the number is outside the range of 20-22 then...
Less than 20 or greater than 22

the answer depends on where you are at, Kitty. are you in a form or in a query? the answer is different for both scenarios

 

[jdraw]

Outlier tasks == Honey Do List ( I guess it's a cultural thing)

 

[The_Doc_Man]

jdraw, I call them "honey-do" items as well. But I was equating a honey-do to a more general category - the "find the outlier" - which for a chemist is a common-place activity. A big part of experimental and analytical chemistry (my wheelhouse) is determining if a sample is outside the norm.

 

[jdraw]

Agree. Honey do may have no bounds

 

[vba_php]

Outlier tasks == Honey Do List ( I guess it's a cultural thing)

i think that would be THREE equal signs draw, not 2.