CODEWITHSUNDEEP
ms-accessms-access-2007ms-access-2010
Prem JAin
Prem JAin

Reputation: 29

Microsoft Access automatically rounds numbers

Under a column that has a number data type. I am trying to enter the number 11.50, but the system is automatically changing it to 12.00.

Upvotes: 0

Views: 5079

Answers (3)

ChrisPadgham
ChrisPadgham

Reputation: 870

When you have the table open in design mode, click on the field in question. In the lower pane you will see properties of the number, change the field size to either Single or Double.

Upvotes: 0

paramosh
paramosh

Reputation: 2258

There are two settings for Number fields Field Size and Decimal Places. At first, you should change Field Size from Integer to either single, double.

Upvotes: 1

anosyria
anosyria

Reputation: 153

because this type numbers can handle only numbers with out any fractions

you must change this datatype to be double

Upvotes: 1

Related Questions