please help me

V

Vijay

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

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

Dirk Goldgar

Vijay said:
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.
Click to expand...

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