Creating a criteria for a query on an automated field

[JBros]

Hello,



I want to make a query under a certain circumstance in one of the fields, which is an calculated field. It shows percentages referring other 2 fields, and I'd like to stablish as a criteria that percentage to be greater than 20%.

I'm not sure what is the syntaxis, as >20, >20%, ">20%"... etc doesn't seem to work. I also edited the null values (there was two of them) if this could cause the error but still struggling to find a solution. Any ideas on how to do that?

Thank you.

[June7]

"doesn't work" means what - error message, wrong results, nothing happens?

Is the field set with percentage format? Possibly the value in the field is actually a decimal so try >0.20

[JBros]

That's right, this was the problem. Thank you very much!