[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