MS Access Sqr() Function
The Sqr()
function in MS Access calculates the square root of a number. The square root of a number is a value that, when multiplied by itself, equals the original number.
Sqr(): Definition and Usage
Sqr()
is a fundamental mathematical function used to find the square root of a positive number. It's frequently used in calculations involving geometry, statistics, or any other area where square roots are necessary.
Syntax
Syntax
Sqr(number)
Parameter Values
Parameter | Description |
---|---|
number |
The number for which you want to find the square root. This must be a positive number. This is required. |
Example
Calculating the Square Root
This example shows how to use the Sqr()
function to calculate the square root of 64.
Syntax
SELECT Sqr(64) AS SqrNum;
Output
SqrNum
-------
8