1. Technology

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.

You can opt-out at any time. Please refer to our privacy policy for contact information.

Discuss in my forum

©2014 About.com. All rights reserved.