Solved Query criteria between two hour/decimal numbers (1 Viewer)

[oxicottin]

I cant get a correct result in my query. I have a field (DelayHours) and I don't want to display anything that's in the range of 9.75 to 14.17. I tried

<"9.75" Or >"14.17"

As my criteria and I still get the results including numbers in that range. The only thing that works but does me no good in a range of numbers is...

Not In ("9.75", "9.83", "14.17")

But that only blocks those numbers. Thoughts?

 

[theDBguy]

Try using AND vice OR.

 

[arnelgp]

Not (Between 9.75 And 14.17)

 

[Galaxiom]

They are numbers and should not be processed as text.

Any comparison must be a complete expression.

WHERE DelayHours < 9.75 OR DelayHours > 14.17

This is another expression that would do it.

WHERE NOT DelayHours BETWEEN 9.75 AND 14.17

 

[Galaxiom]

Also beware of performing any arithmetic or comparisons on floating point numbers. The small errors representing floating point in binary can cause unexpected results.

For example, the answer to the following expression can be quite surprising. (Type it in the immediate window of VBA and press Enter)

? 0.7 * 90 = 63

 

[theDBguy]

Thank you and worked....

Hi. Glad to hear you got it sorted out. Good luck with your project.