Access: Last Function

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

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.

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.