How do I use multiple IFF() condition in Accsess?

Nad · Jan 29, 2006

I want use multiple Iff condition in Acsess databse like we do in Excel.
I am giving an example of Excel.
If(A1=1,"One",if(A1=2,"Two","Three")).

Pls answer me.

Ed Warren · Jan 29, 2006

look under help for IIF function. Works the same way

Ed Warren

Ofer · Jan 29, 2006

In Access you use IIf

IIf([FieldName]=1,"One",iif([FieldName]=2,"Two","Three"))

How do I use multiple IFF() condition in Accsess?

Nad

Ed Warren

Ofer