I need to switch values on a field; values 0 thru 5.

[techexpressinc]

I need to switch values on a field; values 0 thru 5.
0 stays 0
1 goes to 5
2 goes to 4
3 stays 3
4 goes to 2
5 goes to 5

I have coded this for a started for the concept but syntaxly failing.
Q12A: IIf([Q12]=1,5),Iff([Q12]=2,4)


Thx
Russ

 

[rainman89]

Q12A: IIf(([Q12]=1),5,IIf(([Q12]=2),4, IIF(etc...)) <-look at the red!