totn Access Functions

MS Access: Functions - Listed by Category

For easy reference, we have provided a list of all Microsoft Access functions. The list of Access functions is sorted into the type of function based on categories such as string, numeric/mathematical, date/time, advanced/logical, domain aggregate, data type conversion, group by, and file/directory functions.

It is important to note that there are 2 type of functions in Access - functions used in SQL/Queries and functions used in VBA code. Some functions can be used as both, but some can not.

Below is the list of MSAccess functions, sorted by category (ie: type of function).

String Functions

Numeric/Math Functions

Date/Time Functions

Advanced/Logical Functions

Information Functions

Domain Functions

Data Type Conv. Functions

Group By Functions

File/Directory Functions

Miscellaneous Functions