Number format issue Access 2007

  • Thread starter Thread starter WSR
  • Start date Start date
W

WSR

Access 2007.

I've created a database with a number input and I'm getting the following
errors.

I've formatted a field as
Number
Field Size: Single
Format: Currency
Decimal Places: 0

I'm getting the following results
Input 2,065,000,000 but it's rounding it to 2,064,999,936
Input 2,682,000,000 but getting rounded to 2,681,999,872

Any ideas on the reason for this? Do I have that field formatted properly?

You help is GREATLY appreciated!

(B^>)-]=[
 
Thanks Allen.

Putting your solution to work.

Regards,

(B^>)

Allen Browne said:
Single is a floating point type.
Accuracy is only 7 or 8 significant digits.
More info:
http://en.wikipedia.org/wiki/Floating_point#Accuracy_problems

If you want to store large numbers as per your entry, consider using a
Currency field, a Double, or a Decimal field.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


WSR said:
Access 2007.

I've created a database with a number input and I'm getting the following
errors.

I've formatted a field as
Number
Field Size: Single
Format: Currency
Decimal Places: 0

I'm getting the following results
Input 2,065,000,000 but it's rounding it to 2,064,999,936
Input 2,682,000,000 but getting rounded to 2,681,999,872

Any ideas on the reason for this? Do I have that field formatted
properly?

You help is GREATLY appreciated!

(B^>)-]=[
Click to expand...
Click to expand...
 
Back
Top