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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Stop Excel from displaying rounded values 4
Number Field Automatically Rounding Decimals 3
Lookup - Combo Box 1
Access stripping decimal places in query 1
Excel Excel 2007 won't stop rounding down my formula results! 5
Next problem 6
Automatic rounding? 1
Form Rounds up Decimal numbers, WHY? 7

Back
Top