MS Access Functions

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

Returns the ASCII value for the specific character

Returns the character for the specified ASCII number code Concat with &

Returns the full path for a specified drive

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

Extracts a number of characters from a string (starting from left)

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)