[AccessD] another IIF statement question

Mike & Doris Manning mikedorism at adelphia.net
Fri Mar 5 09:46:50 CST 2004


IIf(NOT ISNULL(a), a, IIf(NOT ISNULL(b), b, c))

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Oleg_123 at xuppa.com
Sent: Friday, March 05, 2004 10:20 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] another IIF statement question


I have 3 columns - if one contains a record the other two are blank; and I
an trying to combine them 3 in one column. I was able to combine contest of
2 columns --

(IIF(NOT isNull([Ron Data mid].[SW_Date_Closed]),  [Ron Data
mid].[SW_Date_Closed],[OW_Date_Closed])) AS W_Date_Closed

but i am not sure how to add the third.

i needs to be in the following fashion -
if (a is not null), a, else if (b is not null), b, else c)

any hints ?

(IIF(NOT isNull([Ron Data mid].[SW_Date_Closed]),  [Ron Data
mid].[SW_Date_Closed], (NOT isNull ([OW_Date_Closed]), [MSS_Date_Closed] ))
AS W_Date_Closed,


-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list