How come access is rounding my percentage decimals?

[dannrob]

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?

 

[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.

 

[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?

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]