Open In App

Val() and Sum() Function in MS Access

Improve
Improve
Like Article
Like
Save
Share
Report

1. Val() Function :
val() function returns the number found in the string. In this function, it takes a string as a parameter and it will return the number in the string.

Note : This function will stop reading when the first non-numeric character comes.

Syntax :

Val(string) 

Example-1 :

SELECT Val("234geeksforgeeks12") 
AS ValNum;

Output –

ValNum
234

Example-2 :

SELECT Val("345") 
AS ValNum;

Output –

ValNum
345



2. Sum() Function :
Sum() function returns the sum of the set of value. In this function, the set of value is passed as a parameter and it will return the sum.

Note : Null value will be ignored by this function.

Syntax :

Sum(expression) 

Demo Database for example :

Table name : student

Student_id marks
101 89
102 67
103 40

Example-1 :

SELECT Sum(marks) AS Total 
From student;

Output –

Total
196

Example-2 :

SELECT Sum(marks) AS Total 
From student Where marks>50;

Output –

Total
156

Last Updated : 02 Sep, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads