[AccessD] Multiplying Currency with 6 decimals

Beach Access Software bchacc at san.rr.com
Mon Dec 4 10:38:07 CST 2006


Can you carry the numbers internally as double and only format to currency
on the way out to a report?

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Reuben Cummings
Sent: Monday, December 04, 2006 8:29 AM
To: AccessD
Subject: [AccessD] Multiplying Currency with 6 decimals

I have an application that allows a unit to import a text file which then
shows the TOTAL cash due to a unit.  However, the state keeps some and
therefore the unit gets a percentage sent to them.  The result is how much
cash they actually get.

No problem so far....

However, the state uses a percentage with 6 decimals.  The currency data
type is only four decimals.  Therefore I can't use currency and now I get an
error of several pennies on each calculation.

Any suggestions on how to get the accuracy back?

Thanks.

Reuben Cummings
GFC, LLC
812.523.1017




-- 
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.430 / Virus Database: 268.15.6/566 - Release Date: 12/3/2006
4:36 PM
 




More information about the AccessD mailing list