Number Format

[Ramzi]

Hi every one, I am using M.S Access Xp, I am trying to multiply a number
(Currency Format) with another number for the currency rate (Number
format –Single).

When the currency is a large number, the result will not be accurate??

Example:

100000 * 0.72 = 72000.0028

100000 * 0.70 = 69999.9988



It does not give a fixed number as expected ???

I have to use many decimal places for the currency rate to get accurate
results.



Please Advise…



Thanks…

 

[Ramzi]

Dear Jeff Boyce
Thanks, infact I need many decimal places for the currency rate (more than
4) so I didn't use currency, I used Double format but the problem of the
size of the field, I am trying to minimize the DB size.

Thanks Any way...

 

[Jeff Boyce]

Ramzi

The "Single" numeric format is not an exact value (it's stored in binary, so
there's "binary rounding" involved).

Is there a reason you can't use two values, both of type "currency"? Please
note -- "currency" does NOT mean money (but it can be used for that). In
Access, the "currency" data type stored a numeric value with up to four
decimal places. No rounding.

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/