[AccessD] Multiplying Currency with 6 decimals

Reuben Cummings reuben at gfconsultants.com
Mon Dec 4 10:29:19 CST 2006


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







More information about the AccessD mailing list