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