[AccessD] Bug in access

SELECT CDbl("123.45") AS SomeDouble, BankNames_tbl.BankID, CDbl([BankID]) AS dbl_BankID
FROM BankNames_tbl;

Gives

SomeDouble	BankID	dbl_BankID
123.45	            1	1
123.45	            2	2

Where BankID is an autonumber. 

There's something wrong with JCs installation IMHO.

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: Tuesday, November 10, 2009 2:36 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Bug in access

Oops, you are correct. It still works for me

SELECT CDbl("123.45") AS Expr1, tblMyTable.CPName, CDbl([CPName]) AS Expr2 FROM tblMyTable;


Expr1	CPName	        Expr2
123.45	David McAfee    #Error	
123.45	Bill Gates          #Error	
123.45	Larry Ellison     #Error	
123.45	Megan Fox      #Error	
123.45	123.45	123.45
123.45	678.90	678.9


On Tue, Nov 10, 2009 at 11:06 AM, Charlotte Foust <cfoust at infostatsystems.com> wrote:
> 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?
>
> Charlotte Foust