Expression

[Teri B]

I am trying to write an expression and having trouble. I get the first part of my arguments correct but when I try to add the third I run into trouble. Here is the first part of the expression:

=IIf([completedate]>"",
   "Complete",
   IIf(
      IsNull([CompleteDate]) And ([DueDate]<Date()),
      "Overdue",
      ""
   )
)

This works correctly. When I try and add the last bit it does not work. Here is what I am trying to add

IIf([ReviewDate]<= Date(),"In Process","")

Can anyone help me.

[cactusdata]

Try with:

=IIf(Not [CompleteDate] Is Null,
    "Complete",
    IIf([ReviewDate] <= Date(), 
        "In Process",
        IIf([DueDate] < Date()
            "Overdue",
            Null)))

[zmbd]

@Teri B
When writing nested IIF() functions I usually start out by creating the skeleton code
(would you post back which database you're using)

Start with the outer IIF - notice the stepping of the code 
 stepping your code will help keep things straight in you mind
IIF(condition, 
   true, 
   false
)
 Now add the inner IIF(); in this example an on false 
IIF(condition, 
   true, 
   IIF(condition2
      true,
      false
   )
)
 at this point keep adding and stepping
 - say I want a on true for the 3rd
IIF(condition, 
   true, 
   IIF(condition2
      IFF(condition3, 
         true, 
         false
      ),
      false
   )
)
 
 quite often in VBA I'll comment the code as I go; unfortunately,
 most SQL will not let you add comments
IIF(condition1,
   'on true event condition1 
   true, 
   'on false event condition1 
   IIF(condition2
        'on true event condition2 
      IFF(condition3,
        'on true event condition3
         true, 
        'on false event condition3
         false
      ),
      'on false event condition2
      false
   )
)
 From this point, now that the skeleton is laid out, 
 insert your true and false actions at each branch 
 within the nested functions