Rounding Numbers

  • Thread starter Thread starter Elliott
  • Start date Start date
E

Elliott

How do you stop Access from rounding numbers?
I have changed the decimal place settings but my numbers
keep getting rounded eg. 1.4 gets changed to 1.0
 
Make sure that the Field Size is "Single" or "Double", and not "Integer" or
"Long Integer" (the default is long integer). (Look in table design).
 
You must log in or register to reply here.

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

Number format issue Access 2007 2
Excel Excel 2007 won't stop rounding down my formula results! 5
round function not work property in access 10
Excel Stop Excel from displaying rounded values 4
stop the rounding 4
Digits on right of Decimal points 1
Unwanted Numbers Rounding 6
Access stripping decimal places in query 1

Back
Top