Criteria Is Not Filtering-Please Help

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
 
R

Rover

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?
 
D

Dejan

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.

:)
 
S

sajohn52

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
 
Top