Related Articles

# Abs() and Avg() Function in MS Access

• Difficulty Level : Medium
• Last Updated : 08 Sep, 2020

1. Abs() Function :
In MS Access, the abs() function returns a positive (absolute) number. In this function, either a positive number or a negative number is passed, and it returns the absolute of that number. It takes a number as a parameter and it returns the positive value of that number.

Syntax :

`Abs(number)`

Example –

`SELECT Abs(-240.7) AS AbsNum;`

Output –

AbsNum
240.7

Example –

`SELECT Abs(120.89) AS AbsNum;`

Output –

AbsNum
120.89

2. Avg() Function :
In MS Access, the Avg() function is used for calculating the average of the numbers. In this function, a set of numbers/expression is passed and it returns the average of the input numbers.

Note –
If the null values are given then it will be ignored.

Syntax :

`Avg(expression)`

Table – Stu_Details

101GFG_147
102GFG_278
103GFG_367

Example-1:

```SELECT Avg(MARKS) AS Average
FROM Stu_Details;```

Output –

Average
64

Example-2:

```SELECT *
FROM Stu_Details
WHERE MARKS > (SELECT Avg(MARKS) FROM Stu_Details);```

Output –