[AccessD] IIF statement

have you tried using a case statment

MonthlyAmount =
                  CASE  WHEN dbo.TBLASG_PIPELINE.PRODISYEARLY = '1'
                              THEN dbo.TBLASG_PIPELINE.PRODAMOUNT / 12
                        ELSE dbo.TBLASG_PIPELINE.PRODAMOUNT
                        END



                                                                                                                                               
                      <Oleg_123 at xuppa.com>                                                                                                     
                      Sent by:                         To:       <accessd at databaseadvisors.com>                                                
                      accessd-bounces at databasea        cc:                                                                                     
                      dvisors.com                      Subject:  [AccessD] IIF statement                                                       
                                                                                                                                               
                                                                                                                                               
                      03/05/2004 08:25 AM                                                                                                      
                      Please respond to Access                                                                                                 
                      Developers discussion and                                                                                                
                      problem solving                                                                                                          
                                                                                                                                               




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