gerabsolute.blogg.se

' Add a 1 to the end of the value (For example, if pValue is 12.65

' (Remove the following 3 lines if you require "Round Up" rounding) ' Symmetric rounding is commonly desired so if the value is If pDecimalPlaces 0) And (LNumDecimals > 0) And (LNumDecimals > pDecimalPlaces) Then ' Return an error if the decimal places provided is negative Public Function StandardRound(pValue As Double, pDecimalPlaces As Integer) As Variant ' built-in VBA Round function to provide true (symmetric) numeric Rounding If you want to avoid bankers rounding, you can create your own custom function as follows: ' This function overcomes the bankers Rounding that occurs in the The results would now be displayed in a column called RoundedValue. You can replace Expr1 with a column name that is more meaningful.įor example: RoundedValue: Round(,1) This query will return the UnitPrice rounded to 1 decimal place and display the results in a column called Expr1. In this query, we have used the Round function as follows: Expr1: Round(,1) You can also use the Round function in a query in Microsoft Access. In this example, the variable called LNumber would now contain the value of 210.7. The Round function can be used in VBA code in Microsoft Access. Let's look at how to use the Round function in MS Access: Round (210.67, 1) The Round function can be used in the following versions of Microsoft Access: If this parameter is omitted, then the Round function will return an integer. It is the number of decimal places to round the expression to. The syntax for the Round function in MS Access is: Round ( expression, ) Parameters or Arguments expression A numeric expression that is to be rounded. So, be sure to only use the Round function if this is your desired result.

In these cases, the last digit after rounding is always an even number. If the expression that you are rounding ends with a 5, the Round function will round the expression so that the last digit is an even number. The Round function utilizes round-to-even logic. So before using this function, please read the following: However, the Round function behaves a little peculiar and uses something commonly referred to as bankers rounding. The Microsoft Access Round function returns a number rounded to a specified number of decimal places. This MSAccess tutorial explains how to use the Access Round function with syntax and examples.