[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