Functions (Category List)

The following list contains topics that describe common functions used in Microsoft Access expressions.


CreateObject Function

GetObject Function


Command Function

Shell Function


Array Function

Filter Function

Join Function

LBound Function

Split Function

UBound Function


Asc Function

CBool Function

CByte Function

CCur Function

CDate Function

CDbl Function

CDec Function

Chr Function

CInt Function

CLng Function

CSng Function

CStr Function

CVar Function

Day Function

EuroConvert Method

FormatCurrency Function

FormatDateTime Function

FormatNumber Function

FormatPercent Function

GUIDFromString Method

Hex Function

Nz Method

Oct Function

Str Function

StringFromGUID Method

Type Conversion Functions

Val Function


CurrentUser Method

DDEInitiate Method

DDERequest Method

Eval Method

HyperlinkPart Method

Partition Function


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

Domain Aggregate

DAvg Function

DCount Method

DFirst Method

DLast Method

DLookup Method

DMax Method

DMin Method

DStDev Method

DStDevP Method

DSum Method

DVar Method

DVarP Method

Error Handling

CVErr Function

Error Function

IsError Function

File Input/Output

EOF Function

FreeFile Function

Input Function

Loc Function

LOF Function

Seek Function

File Management

CurDir Function

Dir Function

FileAttr Function

FileDateTime Function

FileLen Function

GetAttr Function


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


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


Abs Function

Atn Function

Cos Function

Exp Function

Fix Function

Int Function

Log Function

Rnd Function

Round Function

Sgn Function

Sin Function

Sqr Function

StDev Function

StDevP Function

Tan Function


InputBox Function

MsgBox Function


CallByName Function

IMEStatus Function

QBColor Function

RGB Function

Spc Function

Tab Function

Program Flow

Choose Function

DoEvents Function

IIf Function

Switch Function

SQL Aggregate

Avg Function

Count Function

Max Function

Min Function

StDev Function

StDevP Function

Sum Function

Var Function

VarP Function


Format Function

HtmlEncode Method

InStr Function

InStrRev Function

LCase Function

Left Function

Len Function

LTrim Function

Mid Function

PlainText Method

Replace Function

Right Function

RTrim Function

Space Function

StrComp Function

StrConv Function

String Function

StrReverse Function

Trim Function

UCase Function