Max Function (Access custom web app)

Office 2013 and later

Returns the maximum value in the expression in a query or table.

Last modified: March 09, 2015

Applies to: Access 2013 | Office 2013


The Max function contains the following argument.

Argument name



A string expression identifying the field that contains the data you want to evaluate or an expression that performs a calculation using the data in that field. Operands in Expression can include the name of a table field, a constant, or a function (which can be either intrinsic or user-defined but not one of the other SQL aggregate functions).