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 | Access 2016

Important note Important

Microsoft no longer recommends creating and using Access web apps in SharePoint. As an alternative, consider using Microsoft PowerApps to build no-code business solutions for the web and mobile devices.

Max(Expression)

The Max function contains the following argument.

Argument name

Description

Expression

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).

Show: