Single is a floating point number, with only around 7 significant digits.
Use Double, or Decimal.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Janie" wrote in message
...
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?