Rounding

  • Thread starter Thread starter Matthew Ellis
  • Start date Start date
M

Matthew Ellis

I am having trouble figuring out why numbers, stored in a general number field with two decimal places are being rounded to the nearest whole number. I have set the properties in the table and the form to General Number with two decimal places and cannot find where this rounding is occuring. Thanks for the help.
 
What's the data type of the number. By default, when you select Numeric, they're Long Integers, which don't have decimal points. You need to change that to Single or Double.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)


I am having trouble figuring out why numbers, stored in a general number field with two decimal places are being rounded to the nearest whole number. I have set the properties in the table and the form to General Number with two decimal places and cannot find where this rounding is occuring. Thanks for the help.
 
Back
Top