Hmmm ... when reading the description of Single it sounds w-a-y different!
Up to seven decimal places and a maximum value of 3.402823 ^ 38
I get it ... I had already decided to go with Double .. but I wanted to
understand the why of the behavior.
So, bottom line is even though the maximum value is significantly higher, if
I want something grater than a 7 digit number, stay away friom Single.
Thanks for the enlightenment!
"Allen Browne" wrote:
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?
.