basic question: decimal, single, double "guy" <guy[ at ]email.com> 30.09.2006 07:17:08 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!

Re: basic question: decimal, single, double "guy" <guy[ at ]email.com> 30.09.2006 10:41:04 i mean...what's the difference between the number field size property: single, double, decimal? "guy" <guy[ at ]email.com> ¼¶¼g©ó¶l¥ó·s»D:%23Q8B0BG5GHA.3592[ at ]TK2MSFTNGP05.phx.gbl... [Quoted Text] > 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! >

Re: basic question: decimal, single, double "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 30.09.2006 10:58:16 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[ at ]email.com> wrote in message news:eEoExzH5GHA.4996[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] >i mean...what's the difference between the number field size property: >single, double, decimal? > > "guy" <guy[ at ]email.com> > ¼¶¼g©ó¶l¥ó·s»D:%23Q8B0BG5GHA.3592[ at ]TK2MSFTNGP05.phx.gbl... >> 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! >> > >

Re: basic question: decimal, single, double "guy" <guy[ at ]email.com> 30.09.2006 11:16:18 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[ at ]NOSPAM_canada.com> ¼¶¼g©ó¶l¥ó·s»D:edGqV9H5GHA.2144[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > 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[ at ]email.com> wrote in message > news:eEoExzH5GHA.4996[ at ]TK2MSFTNGP04.phx.gbl... >>i mean...what's the difference between the number field size property: >>single, double, decimal? >> >> "guy" <guy[ at ]email.com> ¼¶¼g©ó¶l¥ó·s»D:%23Q8B0BG5GHA.3592[ at ]TK2MSFTNGP05.phx.gbl... >>> 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! >>> >> >> > >

Re: basic question: decimal, single, double "Van T. Dinh" <VanThien.Dinh[ at ]discussions.microsoft.com> 30.09.2006 13:27:37 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[ at ]email.com> wrote in message news:eSLQdHI5GHA.1188[ at ]TK2MSFTNGP05.phx.gbl... [Quoted Text] > 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[ at ]NOSPAM_canada.com> > ¼¶¼g©ó¶l¥ó·s»D:edGqV9H5GHA.2144[ at ]TK2MSFTNGP04.phx.gbl... >> 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[ at ]email.com> wrote in message >> news:eEoExzH5GHA.4996[ at ]TK2MSFTNGP04.phx.gbl... >>>i mean...what's the difference between the number field size property: >>>single, double, decimal? >>> >>> "guy" <guy[ at ]email.com> >>> ¼¶¼g©ó¶l¥ó·s»D:%23Q8B0BG5GHA.3592[ at ]TK2MSFTNGP05.phx.gbl... >>>> 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! >>>> >>> >>> >> >> > >