[AccessD] Bug in access

Steve Schapel miscellany at mvps.org
Tue Nov 10 13:45:11 CST 2009


Charlotte,

Well, John did say:
"To test this bug, create an aliased field in a query something like
Select cDbl("123.45") as SomeField, etc etc"

But anyway, it's working correctly for me using a field name too.  And also 
in combination with another function such as:
CDbl(Right(TextFieldEndingWithDigits],2))

Regards
Steve


--------------------------------------------------
From: "Charlotte Foust" <cfoust at infostatsystems.com>
Sent: Wednesday, November 11, 2009 8:06 AM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Bug in access

> Did I miss something or did you guys?  I understood that John was 
> specifically trying to use CDbl against a field name, not an explicit 
> string.  Is that correct, JC?
>
 




More information about the AccessD mailing list