Eliminating $0.00 in field

[sandrao]

I am have trouble eliminating the $0.00 balances in a query. From what I can figure out is that even though the Balance appears as $0.00 in reality it could be anywhere from $0.0012 to $0.009 or something like that.

What I am trying to do re reconcile the Balance field. If the balance reads $0.00 I want it out of the query. Then I would like to find all the balances that appear to be $0.01 to a negative $0.01.

It seem that no matter what is use as critiera I still can't what I want.

Any ideas?

 

[pbaldy]

If you want to find those, try a criteria of

Between -.01 and .01

 

[sandrao]

That has been tried and it still includes the $0.00.

I feel that its a problem caused by the round to the next highest number feature in access. I am not sure what to do about this.

 

[pbaldy]

Well, you said "I would like to find all the balances that appear to be $0.01 to a negative $0.01" which that should do (and of course zero is in that range). What exactly do you want to accomplish?