Percentage Not Filtering

[zgray]

I have a number field that will not filter correctly either on a query, through vba or quick filter. Every filter for any number will work except filtering the number 0.0399. There are records there with that number. IT shows up as an option on the quick filter and when i select it i get nothing.

Im at a loss right now on why this is happening.

 

[Ranman256]

its possible the number is 'bigger' than 0.0399 , but you only see 0.0399
if could be 0.0399448151 so it will never equal.

 

[pbaldy]

If I had to guess, you're seeing .0399 but what's actually stored is .03989999 or whatever (something that rounds to .0399). You may need to apply the Round() function either when saving values or when filtering.

 

[zgray]

If I had to guess, you're seeing .0399 but what's actually stored is .03989999 or whatever (something that rounds to .0399). You may need to apply the Round() function either when saving values or when filtering.

This worked. But why is it doing that when its typed in exactly 0.0399 and the other values work perfectly?

 

[pbaldy]

Hard to say without seeing the data. I assume the other values are what you see.