In MS Access, decimal places is not functioning

[msaeeda]

I set the decimal places function to 2 in the Table Design Properties. MS
Access rounds the number to nearest integer. How do I overcome this
malfunction?

I have tried to delete the field and then reincorporate it and I keep
getting same problem.

 

[John Vinson]

I set the decimal places function to 2 in the Table Design Properties. MS
Access rounds the number to nearest integer. How do I overcome this
malfunction?

It's not a malfunction, it's just obscurity in the documentation! <g>

The default Number datatype is "Long Integer". An integer, by
definition, is a whole number - *no* decimal places.

Your options are to use a Number of type Single (a floating point
number with about seven digits accuracy) or Double (floating point, 14
digits accuracy); or use a Currency datatype rather than a Number.
Currency is a huge scaled integer with exactly four decimal places,
and it does not have the roundoff error which can cause problems with
Single and Double.

John W. Vinson[MVP]
(no longer chatting for now)