Access: First Function

Search

or browse popular tags

Access Functions

Access Functions

Asc function
Abs function
Atn function
Avg function
Choose function
Chr function
Cos function
Count function
CurDir function
Date function
DateAdd function
DateDiff function
DatePart function
DateSerial function
DateValue function
Day function
Exp function
FileDateTime function
First function
Fix function
Format function
Hour function
IIf function
IsDate function
IsNull function
IsNumeric function
Int function
Last function
LCase function
Left function
Len function
Log function
LTrim function
Max function
Mid function
Min function
Minute function
Month function
MonthName function
Now function
Replace function
Right function
Rnd function
Round function
RTrim function
Second function
Sgn function
Sin function
Space function
Sqr function
Str function
StrConv function
Sum function
Switch function
Tan function
Time function
TimeSerial function
TimeValue function
Trim function
Ucase function
Val function
Weekday function
WeekdayName function
Year function

Subscription

Sign up for the free email newsletter for new tips, tutorials and more. Enter your email address below, and then click the button.

Access: First Function

In Access, the First function return a field value from the first record in the result set of a query.

The syntax for the First function is:

First ( expression )

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

Example

Firts(ItemDesired)

This example uses the First function to return the first ItemDesired value.

SQL query

You can also use the First function in a query.

SELECT First([ItemDesired]) AS Expr1
FROM Orders

Tags:

Add To: dzone | digg | del.icio.us | stumbleupon

Comments