Exp() and Count() Function in MS Access

1. Exp() function :
In MS Access, the Exp() function returns e( 2.718281) power raised to a number. In this function, a number will be pass as a parameter and it will return e raised to the power of a specified number.e is a constant which value is equal to 2.718281. It is the base of natural logarithms.

Syntax :

Exp(number)

Example-1 :

SELECT Exp(6) AS ExpNum;

Output –

ExpNum

403.428793492735

Example-2 :

SELECT Exp(1) AS ExpNum;

Output –

ExpNum

2.71828182845905

2. Count() function :
In MS Access, The Count() function returns the total number of eligible records of a query. When a query expression is performed with the help of count function then it will count total records and return that total count number.

Note –
Null values will not be included in the count.

Syntax :

Count(expression)

Consider an example for Demo Database given below.

Table name : Stu_Details.

TEST_ID	USER_ID	MARKS
101	GFG_1	67
102	GFG_2	89
103	GFG_3	35

Example-1 :

SELECT Count(*) AS TOTAL FROM Stu_Details;

Output –

TOTAL

3

Example-2 :

SELECT Count(*) AS TOTAL FROM Stu_Details
Where MARKS>50;

Output –

TOTAL

2