CODEWITHSUNDEEP
ms-accessrounding
SQL-challenged
SQL-challenged

Reputation: 69

Access 2000-Stop Auto Rounding

I am working with a table that someone else designed. The field is designated as a number. I want to enter a 2 digit number with one decimal place. [Ex: 27.5] The field is automatically rounding to the ones place with a 0 in the tenths place. (27.0) The field size doesn't matter, I have tried them all. I put in formatting and an input mask, however it still automatically rounds.

Upvotes: 1

Views: 814

Answers (1)

BIBD
BIBD

Reputation: 15404

Check the table definition.

If it's a Number, it can be an Integer (Byte, Integer, Long Integer) type or a Real (Single, Double, etc.) The integers will always round. Also, if you are using a real type, the Decimal option may have an effect as well

Upvotes: 1

Related Questions