Code:
Rate%: IIf([overdue]<30 = "0,1",IIf([overdue] Between 30 And 59 = "0,15",IIf([overdue] Between 60 And 89 = "0,2",IIf([overdue]>89 = "0,25"))))
/\ /\ /\ /\
You CAN NOT use the equal sign in the expressions.
This appears to work
Code:
Rate2%: IIf([overdue]<30,"0,1",IIf([overdue] Between 30 And 59,"0,15",IIf([overdue] Between 60 And 89,"0,2",IIf([overdue]>89,"0,25","0"))))
Notice there are NO equal signs in any of the IIF() functions. Also I added the last FALSEPART ("0") of the last IIF() function.
I also tried the SWITCH() function and it returns the appropriate value:
Code:
[Rate%] = Switch([overdue] < 30, "0,1", [overdue] <= 59, "0,15", [overdue] <= 89, "0,2", [overdue] > 89, "0,25")