[AccessD] Currency vs Double

Decimal is available as a number data type in a table field but not as a
declaration in a Dim.

Rocky





 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Monday, January 14, 2008 8:58 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Currency vs Double

The problem with doubles is floating point creep.  You can prove it by
merely taking 0 and adding and subtracting 1 repeatedly.  Somewhere in
there, you'll start picking up decimals way over to the right.  If a decimal
type is available, it's better to use that, but in Access, it depends on
what you're doing with the numbers.

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Sunday, January 13, 2008 10:32 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Currency vs Double

 
Dear List:
 
Is there any difference between currency and double when working with
relatively small number - like under a million?  Does currency take care of
rounding errors which would happen in double calculations?
 
MTIA
 
Rocky
 

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

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.516 / Virus Database: 269.19.2/1223 - Release Date: 1/13/2008
8:23 PM