[AccessD] Decimal Data Type

I use CDEC in in VBA when I have to deal with Credit Card numbers as numbers instead of text.  

Mark A. Matte


> Date: Thu, 15 May 2008 05:37:06 -0700
> From: iggy at nanaimo.ark.com
> To: accessd at databaseadvisors.com
> 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

_________________________________________________________________
Windows Live SkyDrive lets you share files with faraway friends.
http://www.windowslive.com/skydrive/overview.html?ocid=TXT_TAGLM_WL_Refresh_skydrive_052008