how to store a decimal number which is not a currency in a table field

[mukesh]

Hi,

I have a field in a table the property of which i have set as a general number with 3 decimal places. I want to enter a weight 1.265 tons but the decimal place do not work.The number gets round up. I do not want to set its property as currency

please help me how to do it.

[VALIS]

Hi,

I have a field in a table the property of which i have set as a general number with 3 decimal places. I want to enter a weight 1.265 tons but the decimal place do not work.The number gets round up. I do not want to set its property as currency

please help me how to do it.

Have you changed the SCALE property in the general properties tab?
It needs to e set to 3 to give 3 decimal places.

[NeoPa]

Set 'Field Size' property to Double and set 'Format' & 'Decimal Places' properties how you need them.

[Killer42]

Set 'Field Size' property to Double and set 'Format' & 'Decimal Places' properties how you need them.

Depending on your data, you might also want to consider Single.

[mukesh]

Have you changed the SCALE property in the general properties tab?
It needs to e set to 3 to give 3 decimal places.

I can't see the SCALE property in the General proeperty tab. Will u explain me step by step

[pragatiswain]

1. Open your Access database.
2. Go to the table and (single) Click on the table and click on the design.
3. Click on the datatype of the Field to be changed and select it to be Number.
4. In the General Tab at the bottom, set the field size Double, Format General Number, Decimal Places to 3 or Auto based on your requirements.

Hope this helps

[rvsa]

Thank you. It worked.