[AccessD] Re: IIF statement

They do not know what they want as a final picture, but as for details
(such as column naemes, table names etc) they want long descriptive names
with spaces (luckily they don't see how I name command buttons and things
like that)


> 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
>
> --
> _______________________________________________
> 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