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