[AccessD] IIF statement

Oleg,
Should work something like this

(IIf([Ron Data mid].DEPT In ("MSS","MID","SW","OW"),[Ron Data mid].[MS
Date Opened])  AS NewDateOpened, [MID_Date_Opened]) AS NewDateOpened)
Paul



Message date : Mar 05 2004, 04:08 PM
>From : Oleg_123 at xuppa.com
To : accessd at databaseadvisors.com
Copy to : 
Subject : [AccessD] IIF statement 
Hey group, i am still trying to figure out how to do else in an IIF t-sql
statement

this part works fine --

(IIf([Ron Data mid].DEPT In ("MSS","MID","SW","OW"),[Ron Data mid].[MS
Date Opened])) AS NewDateOpened,

however i d'like every other department to get data from a differnt column
. How should i do it ?

(IIf([Ron Data mid].DEPT In ("MSS","MID","SW","OW"),[Ron Data mid].[MS
Date Opened])ELSE [MID_Date_Opened]) AS NewDateOpened,

oleg


-----------------------------------------
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
Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month 
www.freeserve.com/anytime