[AccessD] Decimal Data Type

Charlotte Foust cfoust at infostatsystems.com
Thu May 15 10:32:26 CDT 2008


I don't use doubles if I can avoid them.  Floating point creep is worse
to debug than spaghetti code, so when I have to calculate those numbers,
I convert them to decimals then save the result back to doubles! 

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Edward S
Zuris
Sent: Thursday, May 15, 2008 7:16 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Decimal Data Type


 I run into it when working with other types  of older databases such as
DEC VMS systems  or Progress systems, or MAS90 systems, etc.

 If I can, I try to stick to double and long,  as I hate to do work over
because something  was too small.

 For a challenge, find an old IBM book called  the principles of
operation.  It will explain  many of the older data types from IBM's
point  of view.



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Tony Septav
Sent: Thursday, May 15, 2008 5:37 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Decimal Data Type


Hey Gustav
How does Decimal differ from Double or Currency and do you know why it
was added as a data type?  As Edward has confirmed when Access does the
conversion "you have to hunt through the app and fix things by hand".

That said, Decimal should be avoided as data type in tables as it is
known to be buggy. In VBA, however, it can be quite useful.

Just out of curiosity (because I don't know what it is supposed to be
used for) where would you use it in VBA?

Thanks
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list