1. Computing
Send to a Friend via Email

Microsoft Access Function Library

Detailed descriptions of functions available within Microsoft Access. Each entry contains the function's purpose, usage, return values, examples and special cases.

Microsoft Access Function Library: ABS()
The ABS() function returns the absolute value of any numeric expression provided to it as an argument.

Microsoft Access Function Library: Array()
The Array() function is used to create an array from a comma-delimited list of elements.

Microsoft Access Function Library: Asc()
The Asc() function is used to obtain the integer value of the first character in a string.

Microsoft Access Function Library: Atn()
The Atn() function is used to obtain the arctangent value of a number.

Microsoft Access Function Library: CallByName()
The CallByName() function is used to manipulate objects by either executing a method or setting the value of a property.

Microsoft Access Function Library: Choose()
The Choose() function is used to select an item from a list of arguments.

Microsoft Access Function Library: Chr()
The Chr() function returns a string containing a character value.

Microsoft Access Function Library: CurDir()
The CurDir() function returns a string containing the current working directory.

Microsoft Access Function Library: CVErr()
The CVErr() function allows the creation of user-defined errors.

Microsoft Access Function Library: Date()
The Date() function provides the current system timestamp.

Microsoft Access Function Library: DateAdd()
The DateAdd() function allows you to increment a date by a chosen interval.

Microsoft Access Function Library: DateDiff()
The DateDiff() function returns the difference between two dates.

Microsoft Access Function Library: DatePart()
The DatePart() function returns the requested piece of a date.

Microsoft Access Function Library: DateValue()
The DateValue() function returns a date variant containing the date corresponding to the input.

Microsoft Access Function Library: Day()
The Day() function returns an integer corresponding to the day of the month (1-31) corresponding to the input date.

Microsoft Access Function Library: DDB()
The DDB() function returns a double value containing the periodic depreciation of an asset using the double-declining balance method (or other method, as specified).

Microsoft Access Function Library: EuroConvert()
The DateValue() function returns a date variant containing the date corresponding to the input.

Microsoft Access Function Library: Exp()
The DateValue() function returns a date variant containing the date corresponding to the input.

Microsoft Access Function Library: FV()
The FV() function returns the future value of an annuity.

Microsoft Access Function Library: Hex()
The Hex() function converts a whole number into a string containing its hexadecimal representation.

Microsoft Access Function Library: Hour()
The Hour() function converts a numeric or string expression containing a time value into an integer between 0 and 23 representing the hour of the day within that time value.

Microsoft Access Function Library: IIf()
The IIf() function allows the conditional return of different values depending upon whether an expression evaluates to true or false.

Microsoft Access Function Library: InStr()
The InStr() function returns a number corresponding to the first location of a substring within a string.

Microsoft Access Function Library: InStrRev()
The InStrRev() function returns a number corresponding to the first location of a substring within a string, with the comparison beginning at the end of the searched string.

Microsoft Access Function Library: Int()
The Int() function returns the integer portion of a given number.

Microsoft Access Function Library: IsArray()
The IsArray function returns a value of true if the referenced variable is an array. Otherwise, it returns false.

Microsoft Access Function Library: IsArray()
The IsArray function returns a value of true if the referenced variable is an array. Otherwise, it returns false.

Microsoft Access Function Library: IsDate()
The IsDate function returns a value of true if the referenced variable is a date or time. Otherwise, it returns false.

Microsoft Access Function Library: IsError()
The IsErrorfunction returns a value of true if evaluating the expression results in an error value. Otherwise, it returns false.

Microsoft Access Function Library: IsNull()
The IsNull function returns a value of true if the referenced variable contains no valid data. Otherwise, it returns false.

Microsoft Access Function Library: IsNumeric()
The IsNumeric function returns a value of true if the referenced variable can be evaluated as a number. Otherwise, it returns false.

Microsoft Access Function Library: Join()
The join() function takes an array of strings and an optional delimiter as arguments and returns a single string that contains each string from the input array, separated by the delimiter (if applicable).

Microsoft Access Function Library: Left()
The Left() function returns the specified number of characters of a string, beginning with the leftmost character.

Microsoft Access Function Library: Log()
The Log() function takes a positive non-zero number as input and returns the natural logarithm of that number as output.

Microsoft Access Function Library: Ltrim()
The Ltrim() function takes a string as input, removes any leading spaces, and returns the result as output.

Microsoft Access Function Library: Len()
The Len() function takes a string as input and returns an integer corresponding to the length of the string.

Microsoft Access Function Library: Lcase()
The LCase() function converts all of the uppercase letters in a string to their lowercase equivalents. Characters that are already uppercase or are non-alphabetic are left intact.

Discuss in my forum

©2014 About.com. All rights reserved.