Access Avg Function
Last updated: August 26, 2026. The Avg aggregate calculates the arithmetic mean of the non-Null values in a query group.…
Category: MS Access Functions
Access Asc Function
Last updated: August 26, 2026. The Asc function returns the character code of the first character in a string. Syntax…
Access Atn Function
Last updated: August 27, 2026. The Atn function returns the arctangent of a numeric expression in radians. Syntax Examples Atn…
Access Abs Function
Last updated: August 26, 2026. The Abs function returns the absolute, non-negative value of a number. Syntax Argument Description number…
Access: Format Function
Last updated: August 25, 2026. The Microsoft Access Format function converts a value into a formatted string. Use it in…
Access IsNull Function
Last updated: August 26, 2026. The IsNull function returns True when an expression contains Null and False otherwise. Syntax Argument…
Access IIf Function
Last updated: August 26, 2026. The IIf function evaluates a condition and returns one value when it is true and…
Access UCase Function
Last updated: August 26, 2026. The UCase function converts letters in a string to uppercase. Syntax Argument Description string Text…
Access Switch Function
Last updated: August 26, 2026. The Switch function evaluates condition/value pairs and returns the value belonging to the first true…
Access Sum Function
Last updated: August 26, 2026. The Sum aggregate adds the non-Null numeric values in a query group. Syntax Argument Description…