How can i stop my access 2007 to stop rounding up my NUMBERSsssssssssss

[mikey222]

appreciate any help that i could get! thanks

 

[namliam]

rounding to what? The default is a long number field, have you tried changing your field to a currency or double field? This has more decimal places....

You will have to be a bit more informative if this doesnt resolve your issue

 

[mikey222]

thank you for replying

i'm trying to input numbers with decimal places, everytime i input a number eg. 12.3 it rounds it to 12.0

i've tried to format the numbers to currency but it still rounds it up...
thank you

 

[namliam]

Once rounded numbers, dont change back to decimals if you change the format.

Also make sure your number of decimals is not set to 0, but i.e. 2 (I think that is default, but one can never be sure)

 

[bboss]

go to table Design view
select the concerned field name
Data Type - number
in General Tab, Set 'Field Size' to 'Single' for 2 decimal places.

 

[missinglinq]

As the Mailman said, the important thing here is to change the Field's Field Size from the Default of Long Integer (Integers are Whole Numbers and have no Decimals) to either Single or Double, depending on how large a Number you're trying to store in the Field. If you want 2 Decimal Places you'll have to set that Property; the Default is 'Auto,' not two.

Setting the Format to Currency isn't going to change a Field defined as a Number/Integer to a Field containing Decimals.

Linq ;0)>

 

[boblarson]

Bboss posting to old threads

go to table Design view
select the concerned field name
Data Type - number
in General Tab, Set 'Field Size' to 'Single' for 2 decimal places.

bboss - why have your posts to date always been answering threads that were posted MONTHS, or YEARS, ago? And, in one case the answer had already been accepted and worked. So it was a pointless post.

 

[missinglinq]

Good question, Bob! Like most people I assumed that this was an active thread!

Someone apparently doesn't have enough work of their own to keep themselves busy!