Janie

Which version of Access?

Where are you doing this? (directly in the table, via a form, ??)

More info, please...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"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?