jwcolby
jwcolby at colbyconsulting.com
Tue Nov 10 14:48:18 CST 2009
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.
>