Functions - Category

MS Access: Functions - Category

Below is a list of the most commonly used functions in Access. These functions can generally be used in either VBA code or SQL/Queries.

String Functions

Asc Chr Concat with & Format (with Strings) Instr InstrRev LCase

Left Len LTrim Mid Replace Right RTrim

Space Str StrConv Trim UCase

Advanced Functions

Case Choose CurrentUser First

iif IF-THEN-ELSE IsDate IsNull

IsNumeric Last Nz Switch

Domain Aggregate Functions

DAvg DCount DFirst

DLast DLookup DMax

DMin DSum

Numeric/Mathematical Functions

Abs Atn Avg Cos Count Exp

Format (with Numbers) Fix Int Max Min Rnd (random number)

Round Sgn Sum Val

Date Functions

Date DateAdd DateDiff DatePart DateSerial DateValue Day

Format (with Dates) Hour Minute Month MonthName Now Second

Time TimeSerial TimeValue Weekday WeekdayName Year

Data Type Conversion Functions

CBool CByte CCur CDate

CDbl CDec CInt CLng

CSng CStr CVar

Functions used by Group By Feature in queries

Avg Count

Max Min

Sum

File/Directory Functions

ChDir ChDrive CurDir

Dir FileDateTime FileLen

GetAttr MkDir SetAttr

Miscellaneous Functions

• Test a string for an alphanumeric value
• Convert currency into words
• Creating a custom round function
• Retrieve the user name from Windows while in an Access database