Numbers are rounding automatically in Access 2003 table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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).
 
Sounds as if the field has a field size of Integer or Long Integer. Change
it to Currency or Single.
 
Back
Top