Criteria Is Not Filtering-Please Help

  • Thread starter Thread starter Anthony
  • Start date Start date
A

Anthony

Good Morning...

I have a query setup to calculate test grades and in the
average score field i tried to set the criteria to filter
out grades 90.00% or above with the expression >="90.00%";
however i'm still seeing all scores. Can anyone tell me
what i'm doing wrong?

Thanks,
Anthony
 
The problem is in your formatting of the data. It is most likely stored
as .9 not "90.00%", so >=.9000 should do it. I'm not sure how you are
setting up the criteria but would it be <.9 that you want to accept?
 
Average field is very likely numeric field, so your
criteria should be >=90.00% or even better >=0.9 since
90.00% is just formatting for 0.9.

:-)
 
I think your being confused between field type and field format. The
database may display 90.00% but store the value as a number between
zero and 1. If it is a number field then >= .9 should solve your
problem.


sajohn52
 
Back
Top