Hi,

Can anyone tell me the right way of writing multiple/Nested IIF statements. I am having a problem with Syntax. Also how many multiple IIF statements can i right in an expression. I am asking this because i have to change a field couple of times based on several conditions......with a single expression which has multiple IIF statements......also can somebody let me if this not possible in SQL is there a way to do this in VBA and add it to the query...to add to it i am not using a form to run this query....

What do you need to do? You can always do it in code.



mmcdonal

"IIf" stands for "Inline Ifs" and by definition must be written on a single line. Get arround the problem by writing some code in the form's Module as follow:

If (condition1) Then
  Code to handle condtion1
ElseIf (Conditon2) Then
  Code to handle condition2
ElseIf (as Many additional conditions as you may have) Then
  Code to handle those conditons
Else (final condtion) Then
  conde to hand the final condion
End If

Each of the "code to handle..." sections could have i"If..then"
statements embedded within it to allow for almost infinite branching possibilities. You might also try "select case" statements.