Skip to content
Related Articles

Related Articles

Exp() and Count() Function in MS Access
  • Last Updated : 01 Sep, 2020

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_IDUSER_IDMARKS
101GFG_167
102GFG_289
103GFG_335

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
My Personal Notes arrow_drop_up
Recommended Articles
Page :