Access Functions (by category)

This article contains links to articles that provide details about common functions used in expressions in Microsoft Access. They are arranged first by group and then are arranged alphabetically at the end of this article.

Tip: Beginning with Access 2010, the Expression Builder has IntelliSense, so you can see what arguments your expression requires.

ActiveX

CreateObject Function
GetObject Function

Top of Page

Application

Command Function
Shell Function

Top of Page

Arrays

Array Function
Filter Function
Join Function
LBound Function
Split Function
UBound Function

Top of Page

Conversion

Asc Function
Chr Function
EuroConvert Function
FormatCurrency Function
FormatDateTime Function
FormatNumber Function
FormatPercent Function
GUIDFromString Function
Hex Function
Nz Function
Oct Function
Str Function
StringFromGUID Function
Type Conversion Functions
Val Function

Top of Page

Database

DDE Function
DDEInitiate Function
DDERequest Function
DDESend Function
Eval Function
Partition Function

Top of Page

Date/Time

Date Function
DateAdd Function
DateDiff Function
DatePart Function
DateSerial Function
DateValue Function
Day Function
Hour Function
Minute Function
Month Function
MonthName Function
Now Function
Second Function
Time Function
Timer Function
TimeSerial Function
TimeValue Function
Weekday Function
WeekdayName Function
Year Function

Top of Page

Domain Aggregate

DAvg Function
DCount Function
DFirst, DLast Functions
DLookup Function
DMin, DMax Functions
DStDev, DStDevP Functions
DSum Function
DVar, DVarP Functions

Top of Page

Error Handling

CVErr Function
Error Function

Top of Page

File Input/Output

EOF Function
FreeFile Function
Input Function
Loc Function
LOF Function
Seek Function

Top of Page

File Management

CurDir Function
Dir Function
FileAttr Function
FileDateTime Function
FileLen Function
GetAttr Function

Top of Page

Financial

DDB Function
FV Function
IPmt Function
IRR Function
MIRR Function
NPer Function
NPV Function
Pmt Function
PPmt Function
PV Function
Rate Function
SLN Function
SYD Function

Top of Page

Inspection

Environ Function
GetAllSettings Function
GetSetting Function
IsArray Function
IsDate Function
IsEmpty Function
IsError Function
IsMissing Function
IsNull Function
IsNumeric Function
IsObject Function
TypeName Function
VarType Function

Top of Page

Math

Abs Function
Atn Function
Cos Function
Exp Function
Int, Fix Functions
Log Function
Rnd Function
Round Function
Sgn Function
Sin Function
Sqr Function
Tan Function

Top of Page

Messages

InputBox Function
MsgBox Function

Top of Page

Miscellaneous

CallByName Function
IMEStatus Function
MacID Function
MacScript Function
QBColor Function
RGB Function
Spc Function
Tab Function

Top of Page

Program Flow

Choose Function
DoEvents Function
IIf Function
Switch Function

Top of Page

SQL Aggregate

Avg Function
Count Function
First, Last Functions
Min, Max Functions
StDev, StDevP Functions
Sum Function
Var, VarP Functions

Text

Format Function
InStr Function
InStrRev Function
LCase Function
Left Function
Len Function
LTrim, RTrim, and Trim Functions
Mid Function
Replace Function
Right Function
Space Function
StrComp Function
StrConv Function
String Function
StrReverse Function
UCase Function

Top of Page

Functions (alphabetical)

Abs Function

Array Function

Asc Function

Atn Function

Avg Function

CallByName Function

Choose Function

Chr Function

Command Function

Cos Function

Count Function

CreateObject Function

CurDir Function

CVErr Function

Date Function

DateAdd Function

DateDiff Function

DatePart Function

DateSerial Function

DateValue Function

DAvg Function

Day Function

DCount Function

DDB Function

DDE Function

DDEInitiate Function

DDERequest Function

DDESend Function

DFirst, DLast Functions

Dir Function

DLookup Function

DMin, DMax Functions

DoEvents Function

DStDev, DStDevP Functions

DSum Function

DVar, DVarP Functions

Environ Function

EOF Function

Error Function

EuroConvert Function

Eval Function

Exp Function

FileAttr Function

FileDateTime Function

FileLen Function

Filter Function

First, Last Functions

Format Function

FormatCurrency Function

FormatDateTime Function

FormatNumber Function

FormatPercent Function

FreeFile Function

FV Function

GetAllSettings Function

GetAttr Function

GetObject Function

GetSetting Function

GUIDFromString Function

Hex Function

Hour Function

IIf Function

IMEStatus Function

Input Function

InputBox Function

InStr Function

InStrRev Function

Int, Fix Functions

IPmt Function

IRR Function

IsArray Function

IsDate Function

IsEmpty Function

IsError Function

IsMissing Function

IsNull Function

IsNumeric Function

IsObject Function

Join Function

LBound Function

LCase Function

Left Function

Len Function

Loc Function

LOF Function

Log Function

LTrim, RTrim, and Trim Functions

MacID Function

MacScript Function

Mid Function

Min, Max Functions

Minute Function

MIRR Function

Month Function

MonthName Function

MsgBox Function

Now Function

NPer Function

NPV Function

Nz Function

Oct Function

Partition Function

Pmt Function

PPmt Function

PV Function

QBColor Function

Rate Function

Replace Function

RGB Function

Right Function

Rnd Function

Round Function

Second Function

Seek Function

Sgn Function

Shell Function

Sin Function

SLN Function

Space Function

Spc Function

Split Function

Sqr Function

StDev, StDevP Functions

Str Function

StrComp Function

StrConv Function

String Function

StringFromGUID Function

StrReverse Function

Sum Function

Switch Function

SYD Function

Tab Function

Tan Function

Time Function

Timer Function

TimeSerial Function

TimeValue Function

Type Conversion Functions

TypeName Function

UBound Function

UCase Function

Val Function

Var, VarP Functions

VarType Function

Weekday Function

WeekdayName Function

Year Function

Top of Page

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×