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