Microsoft access decimal problem!!?

Question

If i input my data in the database form for example 4.8 units it changes automaticly to 5. where can i change this? i went thru every setting!!

Answer 1

Open your table. Change into Design view. Now you see the name of every column in a line, and beside it, the data type. The one beside your column will say "Number". Click into it. Below all lines, there is a list of the properties of your column. The first one will say something like "long integer". When you click on it, you'll see that it is a drop-down box. Change it to "Double", save your changes, close the table and open it in data view again. Now you can enter your data.

Answer 2

In the "Table Design", change the setting of the "Field(s)" to edit as follows:

Field Size = Double
Format =
Decimal Places = Auto
Input Mask =
Default Value =
Validation Rule =
Validation Text =
Required = No
Indexed = Yes (Duplicates OK)

Hope this solves your problem...

Answer 3

In Design view, make the Data Type "number", then on the General tab below set the decimals to whatever you want.

Answer 4

Change the column cells format to number with 2 decimal places

Answer 5

it seems like you have your data set to be an integer value rather than a decimal