[AccessD] Decimal

Hi Charlotte

I don't think you can put a general rule for the best replacement for Decimal. Quite often Currency would be the first alternative choice. Double - and indeed Single - may introduce new issues in an existing app.

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.

/gustav

>>> cfoust at infostatsystems.com 14-05-2008 21:53 >>>
Decimal is a data type that was not supported in earlier versions of
Access, although it was in VB and I believe in some other Office apps.
Change it to a floating point (single or double) for Access.  

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
Sent: Wednesday, May 14, 2008 12:28 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Decimal

Hey All
Can anyone tell me what a Data Type - Decimal means.
Everytime I convert an application to 2003 it converts my query specs to
Decimal, which has never happened before and of course the program
crashes.