[AccessD] Re: IIF statement

If "management" knows what it wants then there is usually some sort of
misunderstanding :O)

mark

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Oleg_123 at xuppa.com
Sent: 05 March 2004 17:55
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Re: IIF statement


 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


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com