Access: First Function

In Access, the First function returns the first value from the result set of a query.

The syntax for the First function is:

First ( expression )

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

For example:

First (SupplierID)

In this example, the First function would return the first SupplierID value.

SQL/Queries

You can use the First function in a query.