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

Found this via Google -- related to ACC2000

http://support.microsoft.com/kb/225931

"The CDec() function is supported in Visual Basic for Applications code, but
not in Access queries."
"Create a custom function that uses the CDec() function. Call this custom
function from your Access query. For example:

   1. Create a new module and type the following code:

      Function NewCDec(MyVal)
         NewCDec = CDec(MyVal)
      End Function
      					

   2. Save and close the module.
   3. Type MyID: NewCDec([CategoryID]) in the Field row of a query. Note
that when you run this function, it returns a valid value for the MyID
field."

jack

-----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
No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 9.0.704 / Virus Database: 270.14.59/2494 - Release Date: 11/10/09
02:38:00