Category: MS Access Functions

In Access, the Cos function returns a double containing the cosine of an angle. The syntax for the Cos function…

In Access the Chr function returns the character associated with the specified ANSI code. The syntax for the Chr function…

In Access, the Avg function calculates the arithmetic mean of a set of values in a select query. The syntax…

In Access, the Asc function returns an integer representing the ANSI code corresponding to the first character in a string.…

In Access, the Atn function returns a double containing the arctangent of a number. The syntax for the Atn function…

In Access, the Abs funtion returns the absolute value of a number. The syntax for the Abs function is: Abs(…

In Access, the Format function returns a string containing an expression formatted according to instructions contained in a format expression.…

In Access, the IsNull function returns a boolean value that indicates whether or not an expression contains no valid data…

In Access, the IIF function returns one of two arguments depending on the evaluation of an expression. The syntax for…

In Access, the UCase function returns a string in which all letters of an argument have been converted to uppercase.…