Using IIF function - need some help please

[RBPM]

Here is my problem using IIF -

Have a table that has the following columns:

A) Date to review TD
B) Date to review CW

The values in these columns are text values for dates i.e. 5/1 , 5/2, etc.

I am trying to create a new column C based on the values found in A & B

For example:

Row Column A Column B Column C
1 5/1 blank TD
2 blank 5/1 CW
3 5/1 5/1 TD & CW

I can get the proper results for rows 1 & 2 using the IIF function but haven't been able to get the proper result for row 3. Can anyone help?

 

[Golom]

IIF ([Column A] IS NULL, "TD",
IIF ([Column B] IS NULL, "CW",
     "TD & CW" ))

But you may still need to deal with the circumstance where both [Column A] and [Column B] are NULL.

 

[PHV]

IIf(IsNull([A]), "CW", IIf(IsNull(, "TD", "TD & CW"))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[earthandfire]

Or

IIF((IsNull([A]) And IsNull(),"",PHV's solution)

 

[RBPM]

Thanks for your replies. Much appreciated got what I wanted via the following:

Week of 5/1: IIf([A]="5/1",IIf(="5/1","TD & CW Revw","TD Revw"),IIf(="5/1","CW Revw",Null))