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
Access Expert 26
Seminars
SQL 2
Search
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips
|