Numbers are rounding automatically in Access 2003 table

H

Haraki74

I have a simple table listing sizes of products then costs. When I enter a
cost of say $2.14, the number automatically rounds down to 2.00. $1.77 also
rounds to $2.00. Any ideas?

Thanks
haraki74
 
D

Douglas J. Steele

Sounds as though you may have accidentally left the Field Size as the
default Long Integer when you made the field numeric. Change it to Single
(or Double).
 
K

Ken Snell [MVP]

Sounds as if the field has a field size of Integer or Long Integer. Change
it to Currency or Single.
 
Top