This article contains links to articles that provide details about common functions used in expressions in Access. They are arranged first by group and then are arranged alphabetically at the end of this article.
ActiveX
Application
Arrays
Array Function Filter Function Join Function LBound Function Split Function UBound Function
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
Database
DDE Function DDEInitiate Function DDERequest Function DDESend Function Eval Function Partition Function
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
Domain Aggregate
DAvg Function DCount Function DFirst, DLast Functions DLookup Function DMin, DMax Functions DStDev, DStDevP Functions DSum Function DVar, DVarP Functions
Error Handling
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
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
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
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
Messages
Miscellaneous
CallByName Function IMEStatus Function MacID Function MacScript 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 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
