Round the decimal portion on a field not the integer

I need to round the decimal portion on a field. When I use the ROUND instruction for a field, it rounds the integer portion. For example: 2.589 , with the instruction the result is 3, and I need it to be 2.6 Please tell how can I do it.

Sponsored Links:

Related Topics

How to NOT Round decimals....?
I'm trying to create a form view of a table for data entry, and I have a field for gram weight, but it keeps rounding my value. I try to enter any decimal value and it will round it to the nearest integer.

I have both the table field and the form field set to 2 places for decimals and have tried changing the format from long integer, to double, to Single, to decimal. some round up.

Some round down. But nothing lets the value stay as I enter it. I'm aware I can change it to a text field, but I need to perform a calculation on the value I enter.


Numbers won't Round
Im trying to construct a query for a report that calculates the internal volume of pipes in litres accurate to two decimal places, but when I view the query the volumes come back with 13 or so decimal places. Im using a function to calculate the internal volume like so.

InternalVolume = Round(((Mysgl_Length * 0.25 * Pi * (Mysgl_ID / 1000) ^ 2) * 1000), 2)

Ive set the field to a general number with two decimal places and even used the Round function within the query. The question is why wont the numbers round down to the number of places Im specifying


Integer value without rounding
How do you get just the integer value of a number without any rounding?

If I round (179.839996) I'll get 180 - it rounds up to 180. I juest need the get the the numbers to the left of the decimal without any rounding


Rounding to 2 decimal places
I am computing a value based on a %. If I round and the answer is say 100.125 the result is 100.12 instead of 100.13.

If I add 0.005 I will get the correct value for this, but if I get an answer of say 100.3848 and I round it after adding the .005, my answer is wrong.

My problem would be solved if I could test the number of digits after teh decimal place.

using the right(Cinput, 1) function to test the last decimal, it returns either the 2nd, 3rd or 4th digits depending on how many decimal places there are.


Changing decimal places
The results of our analysis may have decimal places ranging from 0-4. I have a field in the table holding the analytical results to tell how many places right of the decimal to print.

How do I use that integer to format the control printing the result on a form. I don't wish to have separate reports for differing decimal places.


Creating a custom round function
I have an Overtime form for the employees. My problem is that while calculating the value, I need the following rules to apply:
If the fraction portion of the number is below 0.5, then I want to round the number down.
If the fraction portion is greater than or equal to 0.5, then the fraction should be 0.5.
For example, a value of 6.7 hours should display as 6.5.


decimal rounding up to next whole number
I have some unbound text boxes on my form not attached to any tables coz I'm doing

calculations. I want my total to round off to the higher whole no. ie: 1.23 to 2

I have format set to fixed and decimal to "0" I can't find any other property to do this. I think in table design
one can do this with integer setting, but as I say my text boxes are not bound to any table.


Droping the fraction of a double into an INT
I have more experience with other computer languages, that, when you cast a double type variable into an integer, you merely lose whatever came after the decimal point.

Now me having this experience, crafted the solution of a problem that depending on this behavior, only to notice that this function:
someInt = CInt(4.51) '(or higher)
will actually round the number to 5 for me. I was depending on the different behavior.

Any simple way to just lose the decimal


Round the time to Integer values
I would like to Round the time what I have bellow to integer Values (10 min peridos ) for example

May I pefrom this by creating Query or Table is enough?


Decimal Values on a form
I have data entry form and need to enter some decimal values like:

12.36 and 14.67 but

even though I change the auto decimal to "2" and the format to standard its show the form field like then 00.00 but when enter any deicmal data it comes up with round up


Round Function
In Access, the Round function returns a number rounded to a specified number of decimal places. However, the Round function behaves a little peculiar.


Wingding characters with decimal values
for suggestions.

Within a specific report, I have a field named Rating that will have a numerical range from 0.0-5.0. Basically, I was hoping to insert a ratings view by utilizing special wingdings characters. I can achieve the results I need until the introduction of a decimal value.

For example, if a Rating is 2.0, the formula =String([RATING],"") produces:

** (2 solid stars). No wingding font to display

Which is exactly what I need. However, when of the decimal rating ranges from 0.50-.0.75 I would like for another character to trail. For example, suppose the rating is 4.6, the result I hope to obtain same as above, however decimal portion would be a different character. Basically for full stars, and for half stars.

Any recommendations


Rounding Percentages in Report
I have a report in which I am calculating and then summing percentages. I need to round the percentages down to the nearest whole number.

My percentages are 19.23%, 79.49% and 1.28%. When I format the text box to decimal places 0, I get 19%, 79% and 1% and my total is 100%. However, if you manually sum these threepercentages, they total 99% and not 100%.

I have tried to incorporate the round function using the formula below but it returns 20%, 80% and 0%.

=Round([TotalDelivered]/[txtTotalDelivered],1)


Double vs. Decimal Data Type - Access 2010
I have an account number field with a number of 17 digit values. Our default for that field in our Access tables has been a double data type. That worked fine until we started getting the large account numbers.

Many, such as 62078190357102307, behave fine. That account number imports as expected.

However, if the account number ends in 199, 299, etc., such as 10024912715100199, it comes into the table as 10024912715100200 if the field format is double.

In the source DB2 table, the field is Decimal 20. If I format the Access table field as Decimal 20, all is well.

My problem is that we have the account number field everywhere in multiple databases, tables, queries and reports. It is a key field for us. Changing it everywhere would be a challenge.

Can someone enlighten me as to why the fields appear to round if they end in 99. Is there anything I can do to prevent that, short of reformatting all of my account number fields as decimals?


Rounding of number not desired
I am trying to make two calculated fields come out looking the same in a query. When I hover the mouse cursor over them one has a value 48.9932 and the other has a value of 48.9974. When the mouse cursor is moved away they round off and display as currency as $48.99 and $49.00 respectively. In the calculated formula for each of them there are some 3 decimal place multipliers used. Could this be causing the problem. I must have the 3 digit multipliers in the formula. I have tried changing number types, decimal places, etc in the underlying table, but nothing seems to prevent them from displaying this way. In the calculated formula for each of them there are some 3 decimal place multipliers used. Is there a way to make them come out even by ignoring the 3rd and 4th decimal place


Number of Decimals Places Isn't Working
I wanted to change the Currency field to Numeric. For example: $29.95 --> 29.95

I did not define the number of decimal places so the program assumed no decimal places so it changed $29.95 to 30.

I went back in to design view and selected 2 decimal places, closed the table and re-opened it expecting (hoping) that 2 decimal places would be showing for the price in 16511 records.

The 2 decimal places are NOT presenting. For example, 29.95 is still presenting as 30.

How do I get 2 decimal places to present?


Sum(Round) gives incorrect value.
I have along list of values of which I need to sum together. The issue I have is, with the list (sorry in advance):

I use SUM(Round(value,6)) and get the result "1.19371179607697E-12". What I expect, and what has been worked out in Excell / calculator is zero. I believe that Access 97 has some mathematical issues with decimal sums? Is there a way to get the desired result?

The field type on the value is (Double, Fixed, 6dcp). I was working on this yesterday with 1dcp and was fine with smaller values


Fill my decimal places with 0's when I know there are real numbers?
I have an exchange rate field which is calculated to ten decimal places. This is looked up from a date field and a currency field via a select query which when I test that shows to 10 correct full decimal places.

When I try and show this calculated exchange rate in my form it gives me 10 decimal places but after the first four it just gives 0's when I know there are actuals there.

I've tried various formats including General Number, Fixed etc and currently have it set as 0.0000000000 and my decimal places setting as 10.

I've even currently got my control source as:
=FormatNumber(ExchangeRate([Start Date],[CurrencyID]),10)


Round Up/Down 4 Decimals to 2
I am working in MS Access 2003. I have imported tables that have 12 digit text fields that look like this 000000012572. I have created a new text box on my report that has a control source of =Val([fieldname]) and a format of #\.0000 so that 000000012500 now displays as 1.2572. This is great for most of my fields except one. I need one of my fields to round the decimal to 2 places so that 1.2572 would be displayed as 1.26. Does anyone have any suggestions on how to do this


convert long decimal number to 2 decimal places
I have dividing one int field by another and the results varies from 0 to 9999.999999999999

When I add a SUM(newnumber) into a group field in reports I get the error :
This expression is typed incorrectly, or it is too complex to be evaluated.

I think it might have something to do with the large decimal place.

from my query can I convert this number to 9999.99 at most ?
ie, only 2 decimal places.
Access should then beable to add the values,, correct