First() and Last()Function in MS Access

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

My Personal Notes arrow_drop_up

Save