Mid() and Len() Function in MS Access

First() and Last()Function in MS Access

Last Updated : 14 Sep, 2020

1. First() Function : In MS Access, the First() function is used to return a field value from the first record in the result set returned by a query. Syntax :

First(expr)

Parameter :

expr : It represents a string expression identifying the field that contains the data we want to use or an expression that performs a calculation using the data in that field.

Returns : It returns the first record in the result set. Table – Employee_Details

Emp_id	Emp_Name	Experience
101	Amit	5
102	Rahul	10
103	Suhani	8

Example-1 :

SELECT First(Emp_id) AS EmployeeId FROM Employee_Details;

Output :

EmployeeId
101

Example-2 :

SELECT First(Emp_Name) AS FirstEmployee FROM Employee_Details;

Output :

FirstEmployee
Amit

2. Last() Function : In MS Access, the Last() function is used to return a field value from the last record in the result set returned by a query. Syntax :

Last(expr)

Parameter :

expr : It represents a string expression identifying the field that contains the data we want to use or an expression that performs a calculation using the data in that field.

Returns : It returns the last record in the result set. Example-2 :

SELECT Last(Emp_id) AS EmployeeId FROM Employee_Details;

Output :

EmployeeId
103

Example-2 :

SELECT Last(Emp_Name) AS LastEmployee FROM Employee_Details;

Output :

LastEmployee
Suhani

Mid() and Len() Function in MS Access

jana_sayantan

Improve

Article Tags :

SQL
DBMS-SQL

Similar Reads

Fix() and Format() Function in MS Access

1. Fix() Function : In MS Access, the fix() function returns the integer part of a number. In this function, a number will be pass as a parameter and it will return the integer part of that number. Syntax : Fix(number) Example-1 : SELECT Fix(-75.43) AS FixNum; Output - FixNum -75 Example-2 : SELECT

Max() and Min() function in MS Access

1. Max() Function : max() function return the maximum value of given set. In the function a query is passed and in the eligible records which value will be maximum that will return as result. A expression will be pass as parameter and it will return the maximum value in the expression. Syntax : Max

Left() and Right() Function in MS Access

1. Left() Function : In MS Access the Left() function extract the string from the left of the string. In Left() function The string and the no of the string will be passed. And it will return the string of size the pass number from the left of the string. Syntax : Left(string, number_of_chars) Examp

Mid() and Len() Function in MS Access

1. Mid() function : In MS Access the mid() function will extract the string from a given position. In this function 3 parameters will be passed first will be the string and second will be the starting position and last will be the length of the string. Syntax : Mid(string, start, length) Example-1 :

Atn() and Cos() Function in MS Access

Atn() Function : In MS Access, The Atn() function returns the arctangent of a number. It takes a number as a parameter and it will return the arc tangent of that number. It will help to perform the mathematical operation of trigonometry. Syntax : Atn(number) Example1 - SELECT Atn(50) AS AtnNum; Outp

Chr() and Asc() Function in MS Access

1. CHR() Function : The Chr() function returns the character for the given ASCII number code. The Chr function takes an integer as a parameter and returns the respective character. It works opposite to ASC() function. Syntax - Chr(ASCII number code) Parameter - Required; An integer. Return - A chara

LTrim() and RTrim() Function in MS Access

In Microsoft Access, managing string data effectively is essential when working with databases. Often, strings may contain unnecessary spaces either at the beginning or the end of the text which can affect data processing, presentation and analysis. MS Access provides two useful functions such as LT

Exp() and Count() Function in MS Access

In MS Access, functions like Exp() and Count() play vital roles in data manipulation and analysis. The Exp() function is used for mathematical computations, specifically to calculate the exponential value of a number, where e (approximately 2.718) is raised to a specified power. In this article, We

Val() and Sum() Function in MS Access

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("2

Abs() and Avg() Function in MS Access

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