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