> and < formula not working right

I have a report that I am trying to say if one field is greater than 95 but less than 105 it should change the field value to Y or N depending on whether it falls within this range.  Looks like it will say Y at the 100% mark, but one value is at 106 and still says Y.  

If ({@Accuracy} >95 or {@Accuracy} < 105) then "Y" else "N"

Can you see any issue?
Kim WilliamsonSystems AdministratorAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
vastoConnect With a Mentor Commented:
You need to use AND instead of OR.
OR will be awlays true because the value will be either over 95or less than 105. 106 is over 95 nad that is why is true.

You need to use AND:
If ({@Accuracy} >95 AND {@Accuracy} < 105) then "Y" else "N"
0
 
Kim WilliamsonSystems AdministratorAuthor Commented:
Duh!  It's always the little things.  Thanks!
0
All Courses

From novice to tech pro — start learning today.