Nested IIF for two comparisons

[aflamin24]

Hi,

I would like to alter this statement so that any number less than 20 is "PRIMARY", any number between 20 and 26 is "SEC" and any number greater than 26 is "SEC2". I think I need to add another IIf() but I'm not really sure of the syntax. Thanks in advance if anyone can help me.



SEC_NR: IIf((Left([BAY_NR],2)>=26),"SEC2","PRIMARY")

[pbaldy]

I think you'll find the Switch() function simpler. If you want to stick with the nested IIf(), you'd place a second IIf() in the False argument of the first, testing for >= 20.

[aflamin24]

Thanks for the help, and next time I will go with the Switch() for sure.

[pbaldy]

No problem.