[AccessD] IIF statement

Hi Oleg

Don't know much about T-SQL but how about this:

  (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