I am using if condition on an unbounded textbox to display some value according to certain criteria. But its only validating the first statement. I know there will be some logical error that is driving the wrong result.
here is the statement
when it executes, it display A+ for every field. i assume that there is some error in the >= expression
here is the statement
Code:
=IIf([fmttl]/[fmmttl]*100 >"90","A+", IIf([fmttl]/[fmmttl]*100 >="80","A", IIf([fmttl]/[fmmttl]*100 >="70","B", ,"Fail")))
when it executes, it display A+ for every field. i assume that there is some error in the >= expression