|
||||||
|
Decimal vs. Double By Richard Rost 16 months ago Decimal vs. Double Number Field Sizes in Access In this Microsoft Access tutorial I'm going to teach you the difference between decimal and double number types, their specifications, benefits & problems, and when you should use each of them. Avery from Burlington, Vermont (a Platinum Member) asks: I'm new to Access. I created a field to hold the number of gallons of fuel a particular vehicle used, and selected the Decimal data type. I try typing in 5.5 and it just rounds to 5. What's the problem? I thought decimal values could have digits after the decimal point. Prerequisites
Links
Recommended Courses
Notes
Keywordsaccess 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Double, decimal, floating point, fixed point, precision, scale, some data may be lost, the decimal field's precision is too small to accept the numeric you attempted to add
|
||||
| |||
Keywords: TechHelp Access Double, decimal, floating point, fixed point, precision, scale, some data may be lost, the decimal field's precision is too small to accept the numeric you attempted to add PermaLink Decimal vs. Double in Microsoft Access |