If Condition Not Giving Proper Result

[vagues0ul]

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

=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

 

[arnelgp]

remove the double quote on 90, 80, 70, etc...

 

[arnelgp]

Switch([fmttl]/[fmmttl]*100 >90, "A+",[fmttl]/[fmmttl]*100 >=80, "A", [fmttl]/[fmmttl]*100 >=70,"B", True,"Fail")

 

[vagues0ul]

Switch([fmttl]/[fmmttl]*100 >90, "A+",[fmttl]/[fmmttl]*100 >=80, "A", [fmttl]/[fmmttl]*100 >=70,"B", True,"Fail")

are you recommending to use the SWITCH statement ?

 

[arnelgp]

yes and its very straigh forward.

 

[vagues0ul]

yes and its very straigh forward.

as always.. you helped me out like a charm.


going to post another question. Hope you will solve it again