View Single Post
  #1  
Old March 17th, 2010, 03:43 PM posted to microsoft.public.access.tablesdbdesign
Janie
external usenet poster
 
Posts: 100
Default Why won't Single take my number?

I have a field with NUMBER datatype, SINGLE field size, Fixed format and 0
Decimals. When I enter the value 100317090407 the number rewrites itself as
100317100000. When I enter 100317090417 again I get 100317100000. When I
enter 100317090499 once again I get 1003617100000.

My number is clearly under then max for a Single 3.402823E38, so what is
going on?

If I set my field size to DOUBLE, I do not encounter the same problem, but I
don't get it. Why do my numbers seem to have a mind of their own with the
SINGLE field size?