I forgot how to do this: I have a table and the field name is 3 position numeric 111, 121, 131 and I am trying to get a text displayed:
BOS $35
SRM $36
OTHER $5,000
So the iff statement is not a simple iif this then and else.
BOS are all the 111
SRM are all the 121
OTHER are all the 131 codes.
Anyone know how to do this?
I have tried creating a new column called location: IIF([SAG]="111","BOS", or IIF([SAG]="121","SRM", or IIF([SAG]="131","OTHER")
this did not work open to suggestions.
Thanks in advance - Ray