[AccessD] Decimal

I'm not clear on just where these Decimals are being changed.  I didn't
get the impression it was in tables.  And I don't know what an Access
2003 conversion has to do with it.

Confused ...

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Wednesday, May 14, 2008 1:46 PM
To: accessd at databaseadvisors.com
Subject: Re: [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.


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