Steve Schapel
miscellany at mvps.org
Tue Nov 10 12:58:54 CST 2009
--------------------------------------------------
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.
--
Regards
Steve