MS Access: Last Function

In Microsoft Access, the Last function returns the last value from the result set of a query.

Syntax

The syntax for the Last function is:

Last ( expression )

expression is the value that you'd like to return from the result set. The Last function only returns the last value in the result set.

Applies To

• Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000

For Example

Last (SupplierID)

In this example, the Last function would return the last SupplierID value.

SQL/Queries

You can use the Last function in a query.