Re: basic question: decimal, single, double

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

--
HTH
Van T. Dinh
MVP (Access)



"guy" <guy@xxxxxxxxx> wrote in message
news:eSLQdHI5GHA.1188@xxxxxxxxxxxxxxxxxxxxxxx
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...

"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx>
¼¶¼g©ó¶l¥ó·s»D:edGqV9H5GHA.2144@xxxxxxxxxxxxxxxxxxxxxxx
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


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"guy" <guy@xxxxxxxxx> wrote in message
news:eEoExzH5GHA.4996@xxxxxxxxxxxxxxxxxxxxxxx
i mean...what's the difference between the number field size property:
single, double, decimal?

"guy" <guy@xxxxxxxxx>
¼¶¼g©ó¶l¥ó·s»D:%23Q8B0BG5GHA.3592@xxxxxxxxxxxxxxxxxxxxxxx
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!









.

Relevant Pages

  • Re: basic question: decimal, single, double
    ... Single (single-precision floating-point) is 4 bytes in size and can hold ... There's also Currency (scaled integer) with is 8 bytes in size, ... Doug Steele, Microsoft Access MVP ... double data type: 3.12345678901235 ...
    (microsoft.public.access.gettingstarted)
  • Re: basic question: decimal, single, double
    ... i have checked the MS ACCESS help and a number of websites...i found all ... Single (single-precision floating-point) is 4 bytes in size and can hold ... There's also Currency (scaled integer) with is 8 bytes in size, ... double data type: 3.12345678901235 ...
    (microsoft.public.access.gettingstarted)
  • Re: Help with time tracking database
    ... "Ken Snell (MVP)" wrote: ... Data type mismatch in criteria expression. ... This always is a query -- if you create and save a query and ...
    (microsoft.public.access.modulesdaovba)
  • Re: Control Source DRIVING ME MAD
    ... Allen Browne - Microsoft MVP. ... Perth, Western Australia. ... > false arguments) were of the same data type as well. ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.formscoding)
  • Re: Date format yyyy
    ... Ken Snell [MVP] wrote: ... > To store just a year value, use a Number data type and set it to Integer ...
    (microsoft.public.access.tablesdbdesign)