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.
