V
Van T. Dinh
That's the "General Number" format!
When the absolute value of the number is really small or
really large, Access will display it in exponential format.
I hope you really the number you posted is about one
hundred billionth. Don't rely on the accuracy of this
value as the truncation and rounding errors can be bigger
than this. Put it this way, for most cases, your number
is virtually ZERO and it may ACTUALLY be ZERO but the
truncation & rounding errors affect the actual ZERO.
HTH
Van T. Dinh
MVP (Access)
When the absolute value of the number is really small or
really large, Access will display it in exponential format.
I hope you really the number you posted is about one
hundred billionth. Don't rely on the accuracy of this
value as the truncation and rounding errors can be bigger
than this. Put it this way, for most cases, your number
is virtually ZERO and it may ACTUALLY be ZERO but the
truncation & rounding errors affect the actual ZERO.
HTH
Van T. Dinh
MVP (Access)