How come access is rounding my percentage decimals?

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
What is the data type of your field? If you want to store percentages, it
can't be Integer, Byte, or Long Integer.
 
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]
 
Back
Top