Free Lessons Courses Seminars TechHelp Fast Tips Templates Topic Index Forum ABCD

 Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

 Access    Excel    Word    Windows    HTML

# Round

## 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.

Query

The results using a Query would be

```	SELECT Round(10.544, 2);
```

FORM

In a Form you could set the Default Value of a Textbox to

```	=Round(10.544, 2)
```
VBA

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)
End Sub
```

Courses Seminars Tips

See this FREE Tip on Round/Int/Fix.

See this FREE Tip on Banker's Rounding.

Search

 Check out these other pages that may be of interest to you:
 11/25/2022 Application Title 11/24/2022 Full HTML Editor in Access 11/24/2022 Change Database Title 11/23/2022 Other Names 11/21/2022 Check Icon File 11/21/2022 Check Icon File 11/18/2022 Archive Records 11/17/2022 InStr Function 11/16/2022 Numbers As Text 11/15/2022 Merge Tables