Functions - Alphabetical

S Access: Functions - Alphabetical

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

Alphabetical Listing of Functions

Abs Asc Atn Avg Case CBool CByte CCur CDate CDbl CDec ChDir ChDrive Choose Chr CInt CLng Concat with & Cos Count CSng CStr CurDir CurrentUser CVar Date DateAdd DateDiff DatePart DateSerial DateValue DAvg

Day DCount DFirst Dir DLast DLookup DMax DMin DSum Exp FileDateTime FileLen First Format (with Dates) Format (with Numbers) Format (with Strings) Fix GetAttr Hour iif IF-THEN-ELSE Instr InstrRev Int IsDate IsNull IsNumeric Last LCase Left Len LTrim

Max Mid Min Minute MkDir Month MonthName Now Nz Replace Right Rnd (random number) Round RTrim Second SetAttr Sgn Space Str StrConv Sum Switch Time TimeSerial TimeValue Trim UCase Val Weekday WeekdayName Year

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