Microsoft Access Function Library

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: 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: 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: 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: 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: Int()

The Int() function returns the integer portion of a given number.

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: InStr()

The InStr() function returns a number corresponding to the first location of a substring within a string.

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.