MeadowLotusSong
New member
- Local time
- Today, 01:17
- Joined
- Jul 16, 2018
- Messages
- 2
I have an 80 option IIf expression in Design View that is too long.
EX:
There is more!
This expression is meant to fill another column in the table with alpha numeric info so it doesn't have to be typed.
Could you please suggestion a function and approach to set this up?
Cheers,
MLs
EX:
Code:
IIf([SampleCt]="1","A05",IIf([SampleCt]="2","A06",IIf([SampleCt]="3","A07",IIf([SampleCt]="4","A08",IIf([SampleCt]="5","A09",IIf([SampleCt]="6","A10",IIf([SampleCt]="7","A11",IIf([SampleCt]="8","A12",IIf([SampleCt]="9","B01",IIf([SampleCt]="10","B02",IIf([SampleCt]="11","B04",IIf([SampleCt]="12","B05",IIf([SampleCt]="13","B06",IIf([SampleCt]="14","B07",IIf([SampleCt]="15","B08",IIf([SampleCt]="16","B09","NoType"))))))))
This expression is meant to fill another column in the table with alpha numeric info so it doesn't have to be typed.
Could you please suggestion a function and approach to set this up?
Cheers,
MLs
Last edited by a moderator: