[AccessD] SPAM-LOW: Re: Bug in access

 >> At least for Access 2000, this is a known bug. I guess it still hasn't been fixed.

ROTFLMAO.  But... we have a pretty new toolbar.

John W. Colby
www.ColbyConsulting.com


James Barash wrote:
> John:
> 
> At least for Access 2000, this is a known bug. I guess it still hasn't been fixed.
> 
> http://support.microsoft.com/kb/225931
> 
> James Barash 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Tuesday, November 10, 2009 3:48 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] SPAM-LOW: Re: Bug in access
> 
> Sorry,
> 
> I miswrote the email.  the failing function is cDec - convert to decimal.  cDec("123.45") in the debug window returns 123.45 as a NUMBER.
> 
> m: cDec("123.45") - an aliased field - in the query window immediately causes an error.
> 
> Sorry for the confusion.
> 
> John W. Colby
> www.ColbyConsulting.com
> 
> 
> Steve Schapel wrote:
>> --------------------------------------------------
>> From: "Heenan, Lambert" <Lambert.Heenan at chartisinsurance.com>
>> Sent: Wednesday, November 11, 2009 7:09 AM
>>
>>> The following SQL runs just fine for me, I Access 2003.
>>>
>>> SELECT CDbl("123.45") AS SomeDouble, BankNames_tbl.BankID FROM 
>>> BankNames_tbl;
>> Same for me in Access 2007.  No problem.
>>
>> I have used CDbl in queries plenty of times, with no problem.  And I 
>> have never heard mention of the type of behaviour you are 
>> experiencing, John.  So it's an oddity.
>>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>