423,311 Members | 1,224 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,311 IT Pros & Developers. It's quick & easy.

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

P: 17
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.
Nov 6 '06 #1
Share this Question
Share on Google+
6 Replies


P: 21
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.
Nov 6 '06 #2

NeoPa
Expert Mod 15k+
P: 30,996
Set 'Field Size' property to Double and set 'Format' & 'Decimal Places' properties how you need them.
Nov 6 '06 #3

Expert 5K+
P: 8,435
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.
Nov 6 '06 #4

P: 17
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
Nov 7 '06 #5

Expert
P: 96
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
Nov 17 '06 #6

P: 1
Thank you. It worked.
Apr 15 '18 #7

Post your reply

Sign in to post your reply or Sign up for a free account.