Number format issue Access 2007

[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^>)-]=[

 

[Allen Browne]

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.

 

[WSR]

Thanks Allen.

Putting your solution to work.

Regards,

(B^>)

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.

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^>)-]=[