How come access is rounding my percentage decimals?

G

Guest

I am trying to put percentage numbers with up to three decimal places but
access holds the decimal and shows a rounded figure. Any answers?
 
D

Duane Hookom

What is the data type of your field? If you want to store percentages, it
can't be Integer, Byte, or Long Integer.
 
J

John Vinson

I am trying to put percentage numbers with up to three decimal places but
access holds the decimal and shows a rounded figure. Any answers?
Click to expand...

Probably because you're using the default Number datatype, which is a
Long Integer. Integers by definition are whole numbers.

Use a Short or Double number instead.


John W. Vinson[MVP]
 

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

Access stripping decimal places in query 1
Field Name - Data Type - Percentage 10
Best Data Type for up to 12-digit Accuracy (up to 9 after dec poin 4
round function not work property in access 10
Rounding question 9
Excel Excel 2007 won't stop rounding down my formula results! 5
stop the rounding 4
Round Percentage 5

Top