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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
In Access you use IIf

IIf([FieldName]=1,"One",iif([FieldName]=2,"Two","Three"))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table default value - expressions 1
Access Property sheet data missing also syntax 0
Using IFF function in textboxes 1
Conditional statement in a text box? 2
Join / Iff Question 1
IIF Statement to return multiple values for a field - JohnW 3
IIF statement 1
Expression - IFF - Performance problem 1

Back
Top