View Single Post
  #1  
Old February 23rd, 2010, 12:54 PM posted to microsoft.public.access.tablesdbdesign
WSR[_2_]
external usenet poster
 
Posts: 40
Default Number format issue Access 2007

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