basic question: decimal, single, double

G

guy

when i input 3.1234567890123456789,
single data type: 3.123457
double data type: 3.12345678901235
decimal data type: 3

does it mean only single and double data type can show decimal point?

thank you!
 
G

guy

i mean...what's the difference between the number field size property:
single, double, decimal?
 
D

Douglas J. Steele

Did you try looking in the Help file?

Single (single-precision floating-point) is 4 bytes in size and can hold
negative values between -3.402823E38 and -1.401298E-45, positive values
between 1.401298E-45 and 3.402823E38 or 0

Double (double-precision floating-point) is 8 bytes in size and can hold
negative values between -1.79769313486232E308 and -4.94065645841247E-324,
positive values between 4.94065645841247E-324 and 1.79769313486232E308 or 0

Decimal is 14 bytes is size and can hold values
+/-79,228,162,514,264,337,593,543,950,335 with no decimal point; or
+/-7.9228162514264337593543950335 with 28 places to the right of the
decimal. The smallest non-zero number it can hold is
+/-0.0000000000000000000000000001

There's also Currency (scaled integer) with is 8 bytes in size, and can hold
values between -922,337,203,685,477.5808 and 922,337,203,685,477.5807
 
G

guy

thank you for your reply.
i have checked the MS ACCESS help and a number of websites...i found all
these answers...

but the problem is....
when i input 3.1415926 in a number field (field size is decimal), ACCESS
automatically changed it to integer 3 and no decimal can be displayed...
why?

sorry, i am a computer idiot only...
 
V

Van T. Dinh

You need to set the Scale of the Decimal Field to 7 (for 7 decimal places)
instead of the default 0.
 
Top