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