Using the Round Function
In this tutorial you will learn how to use the Round Function.
The Round function returns a value round to a given number of decimal places.
=Round( number, [decimalplaces As Long] )
number any valid number expression
decimalplaces a whole number from 0 to
In this example we will use 10.554 rounding to 2 decimal places.
The result is 10.55.
A useful list of Rounding Functions can be found on the MS Website.
The results using a Query would be
SELECT Round(10.544, 2);
In a Form you could set the Default Value of a Textbox to
In a Form add a TEXTBOX control and rename it "txtRound", then you could add the following in the Load Event.
Private Sub Form_Load()
txtRound = Round(10.544, 2)
Access Expert 26
See this FREE Tip on Round/Int/Fix.
See this FREE Tip on Banker's Rounding.
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips