please help me

[Guest]

If i add the 0.56 no. in the access table it will store as either1.00 or 0. i
have fixed the decimal places 2 even though it is not storing what i type,
please help me.

 

[Ken Snell [MVP]]

Change the data type of the field to Single or Double. You likely have it as
Integer or Long Integer, which can store only whole numbers.

 

[Dirk Goldgar]

If i add the 0.56 no. in the access table it will store as either1.00
or 0. i have fixed the decimal places 2 even though it is not storing
what i type, please help me.

Check the field type and size in the table design. Even though the
field type may be Number, if the field size is Long Integer, Integer, or
Byte, then the field can only store whole numbers. You probably want to
use either Single or Double, or else the Currency field type.