Criteria Percentage (1 Viewer)

[kholm]

For a query, I need to weed out those who have a percentage more than 100%. I tried putting >100 in the criteria, but it returns nothing. What am I doing wrong?

 

[David R]

If it's a percentage field, it might be >1 (100% = 1 whole)

 

[kholm]

Yes! Thank you, it was so simple and it worked!