Returns a Double specifying the square root of a number.
Syntax
Sqr ( number )
The required number argument is a Double or any valid numeric expression greater than or equal to zero.
Query example
|
Expression |
Results |
|
SELECT UnitPrice, sqr(UnitPrice) AS SqrUnitPrice FROM ProductSales; |
Returns the values from "UnitPrice" and their square root in the column SqrUnitPrice. |
VBA example
Note: Examples that follow demonstrate the use of this function in a Visual Basic for Applications (VBA) module. For more information about working with VBA, select Developer Reference in the drop-down list next to Search and enter one or more terms in the search box.
This example uses the Sqr function to calculate the square root of a number.
Dim MySqr
MySqr = Sqr(4) ' Returns 2.
MySqr = Sqr(23) ' Returns 4.79583152331272.
MySqr = Sqr(0) ' Returns 0.
MySqr = Sqr(-4) ' Generates a run-time error.
