Oleg_123 at xuppa.com
Oleg_123 at xuppa.com
Fri Mar 5 11:54:41 CST 2004
Oleg, you really need to get rid of the spaces in your column and table
names!!!!!!
>
> Robert
>
:)) I am not the one who comes up with those names, thats what management
wants
>
>
> At 09:15 AM 3/5/2004 -0600, you wrote:
>>Date: Fri, 5 Mar 2004 15:35:07 +0100
>>From: Gustav Brock <gustav at cactus.dk>
>>Subject: Re: [AccessD] IIF statement
>>To: Access Developers discussion and problem solving
>> <accessd at databaseadvisors.com>
>>Message-ID: <323397654.20040305153507 at cactus.dk>
>>Content-Type: text/plain; charset=us-ascii
>>
>>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
>
>
> --
> _______________________________________________
> 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