IIF and Switch Functions?

[dmugan]

Hello,

Is there a function that does not stop when the expression evaluates to True?

e.g.

If field one equalys yes, insert X (don't stop)
if field two equals yes, insert y
If field three equals yes, insert z, (etc...)

Thank you.

 

[MaliciousMike]

Hello,

Is there a function that does not stop when the expression evaluates to True?

e.g.

If field one equalys yes, insert X (don't stop)
if field two equals yes, insert y
If field three equals yes, insert z, (etc...)

Thank you.

IIf([field1]="Yes","X",(IIf([field2]="Yes","Y",(IIf([field3]="Yes","Z",Null)))))

Is this what you mean?

 

[dmugan]

IFF and Switch

Thank you, that will work but isn't there something more convenient like case of or something like that?

 

[dmugan]

IIF and Switch

I'm sorry, no that doesn't work because, in my example, the nested IFF expression stops at the first true value and it should continue...