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

 Glossary New Entries Added Almost Daily! Click here to get on our Mailing List
 Access    Excel    Word    Windows    HTML

# Sqr

## Using the Sqr Function

In this tutorial you will learn how to use the Sqr Function.

The Sqr function returns a Double specifying the square root of a number.

=Sqr( number )

number any valid number expression

In this example we will use 4.

The result is 2.

Query

The results using a Query would be

```	SELECT Sqr(4);
```

FORM

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

```	=Sqr(4)
```
VBA

In a Form add a TEXTBOX control and rename it "txtSqr", then you could add the following in the Load Event.

```	Private Sub Form_Load()
txtSqr = Sqr(4)
End Sub
```

Courses Seminars Search

You can find more about this by searching the website.

 Check out these other pages that may be of interest to you:
 2/2/2023 Import Objects 2/1/2023 Continuous Forms Not Working 1/31/2023 Group On Top 1/30/2023 Association 8 1/27/2023 Math in Fields 1/26/2023 Association 7 1/25/2023 Change Query 1/24/2023 Association 6 1/23/2023 Association 5 1/20/2023 Association 4