[AccessD] Bug in access

Your original question specified CDbl.  Was that incorrect?  Is it
possible the value is too big for Cdec or that you need to change the
precision to handle it?

Charlotte Foust 

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

Lambert,

cdbl() is a different function.  Did you try cDec()?

John W. Colby
www.ColbyConsulting.com


Heenan, Lambert wrote:
> There has to be more to this than meets the eye.
> 
> The following SQL runs just fine for me, I Access 2003.
> 
> SELECT CDbl("123.45") AS SomeDouble, BankNames_tbl.BankID FROM 
> BankNames_tbl;
> 
> Decompile your front end?
> 
> Lambert
>  
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Tuesday, November 10, 2009 12:30 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Bug in access
> 
> I am working on a project where I use a table to dynamically build a
query.  The table has field names in it, and I can just append those
field names into a select string and voila, it works. 
> place the field names you want in the table and a select statement is
created of those fields.  This system is shuffling fields around from
scanned documents (CSV files) to get them into a standard order.
> 
> OK, so I can also use entire functions such as format(Field1,"000.00")
and that works.  cSng(Field1) works.  cDbl(Field1) does NOT WORK.  It
complains that the function cDbl needs two parameters, but if I supply
anything in the second parameter, then cDbl works (no longer complains)
but returns a zero.
> 
> To test this bug, create an aliased field in a query something like
> 
> Select cDbl("123.45") as SomeField, etc etc
> 
> The QBE will immediately complain about cDbl needing another 
> parameter.  Try the same thing with
> cSgl("123.45") and it works just fine.  NOTICE that cDbl() in the
debug window does NOT require another parameter and if you try to
provide one, it will fail to execute.
> 
> The bugs we have to work around.  Sigh.
> 
> But hey, we have a shiny new tool bar.  ;)