Supress values = $0.00

[souladventurer]

I have a currency field in a table.
The default value is $0.00
I need the query to hide values where the field equals $0.00.

I tried placing <>&quot;0.00&quot; in the criteria but recieved a datatype mismatch error.

Thoughts?

Thanks!

 

[evilmousse]

iiii'm not entirely sure what you're getting at doing,
but your data type error stems from &quot;0.00&quot; being text,
and the datatype you're comparing against is currency.

&quot;<> 0&quot; would be more appropriate.