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
Day 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
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

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
CallByName Function
Choose Function
Chr Function
Command Function
Cos 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
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
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
Str Function
StrComp Function
StrConv Function
String Function
StringFromGUID Function
StrReverse 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
VarType Function
Weekday Function
WeekdayName Function
Year Function

Top of Page