Login
  • SQL
  • MS Access Functions

MS Access Functions

MS Access has many built-in functions.

This reference contains the string, numeric, and date functions in MS Access.

MS Access String Functions

Function Description
Returns the ASCII value for the specific character
Returns the character for the specified ASCII number code
Adds two or more strings together
Returns the full path for a specified drive
Formats a value with the specified format
Gets the position of the first occurrence of a string in another
Gets the position of the first occurrence of a string in another, from the end of string
Converts a string to lower-case
Extracts a number of characters from a string (starting from left)
Returns the length of a string
Removes leading spaces from a string
Extracts some characters from a string (starting at any position)
Replaces a substring within a string, with another substring, a specified number of times
Extracts a number of characters from a string (starting from right)
Removes trailing spaces from a string
Returns a string of the specified number of space characters
Splits a string into an array of substrings
Returns a number as string
Compares two strings
Returns a converted string
Reverses a string and returns the result
Removes both leading and trailing spaces from a string
Converts a string to upper-case

MS Access Numeric Functions

Function Description
Returns the absolute value of a number
Returns the arc tangent of a number
Returns the average value of an expression
Returns the cosine of an angle
Returns the number of records returned by a select query
Returns e raised to the power of a specified number
Returns the integer part of a number
Formats a numeric value with the specified format
Returns the integer part of a number
Returns the maximum value in a set of values
Returns the minimum value in a set of values
Initializes the random number generator (used by Rnd()) with a seed
Returns a random number
Rounds a number to a specified number of decimal places
Returns the sign of a number
Returns the square root of a number
Calculates the sum of a set of values
Reads a string and returns the numbers found in the string

MS Access Date Functions

Function Description
Returns the current system date
Adds a time/date interval to a date and then returns the date
Returns the difference between two dates
Returns a specified part of a date (as an integer)
Returns a date from the specified parts (year, month, and day values)
Returns a date based on a string
Returns the day of the month for a given date
Formats a date value with the specified format
Returns the hour part of a time/datetime
Returns the minute part of a time/datetime
Returns the month part of a given date
Returns the name of the month based on a number
Returns the current date and time based on the computer's system date and time
Returns the seconds part of a time/datetime
Returns the current system time
Returns a time from the specified parts (hour, minute, and second value)
Returns a time based on a string
Returns the weekday number for a given date
Returns the weekday name based on a number
Returns the year part of a given date

MS Access Some Other Functions

Function Description
Returns the name of the current database user
Returns a string that contains the value of an operating system environment variable
Checks whether an expression can be converted to a date
Checks whether an expression contains Null (no data)
Checks whether an expression is a valid number

Login
ADS CODE