[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