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

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