Access Topics: Functions (By Category)
View an Alphabetical Listing of Functions
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 | Instr | LTrim | Space | |
| Chr | InstrRev | Mid | Str | |
| Concat with & | LCase | Replace | StrConv | |
| CurDir | Left | Right | Trim | |
| Format (with Strings) | Len | RTrim | UCase | |
Advanced Functions: |
||||
| Case | First | IsDate | Last | |
| Choose | iif | IsNull | Nz | |
| CurrentUser | IF-THEN-ELSE | IsNumeric | Switch | |
Domain Aggregate Functions: |
||||
| DAvg | DFirst | DLookup | DMin | |
| DCount | DLast | DMax | DSum | |
Numeric/Mathematical Functions: |
||||
| Abs | Count | Int | Round | |
| Atn | Exp | Max | Sgn | |
| Avg | Format (with Numbers) | Min | Sum | |
| Cos | Fix | Rnd (random number) | Val | |
Date Functions: |
||||
| Date | DateValue | Month | TimeSerial | |
| DateAdd | Day | MonthName | TimeValue | |
| DateDiff | Format (with Dates) | Now | Weekday | |
| DatePart | Hour | Second | WeekdayName | |
| DateSerial | Minute | Time | Year | |
Data Type Conversion Functions: |
||||
| CBool | CDate | CInt | CStr | |
| CByte | CDbl | CLng | CVar | |
| CCur | CDec | CSng | ||
Functions used by Group By Feature in queries: |
||||
| Avg | Max | Sum | ||
| Count | Min | |||
File/Directory Functions: |
||||
| ChDir | Dir | GetAttr | ||
| ChDrive | FileDateTime | MkDir | ||
| CurDir | FileLen | 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 | |