Home Privacy Policy Feedback Link to us Site Map Forums

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.