[AccessD] IIF statement

Gustav, u ar right

(only the perentasis order is a little different

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


>   (IIf([Ron Data mid].DEPT In ("MSS","MID","SW","OW"),
>   [Ron Data mid].[MS Date Opened]), [MID_Date_Opened])
>   AS NewDateOpened,
>
>
> /gustav
>
>
>> 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



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