Application.DMax (Access)
You can use the DMax function to determine the maximum value in a specified set of records (a domain).
For example, you could use the DMax function in calculated controls on a report to display the largest order amount for a particular customer. The DMax function returns the maximum value that satisfies criteria. If expr identifies numeric data, the DMax function returns numeric values. If expr identifies string data, they return the string that is first or last alphabetically. The DMax function ignores Null values in the field referenced by expr. However, if no record satisfies criteria, or if domain contains no records, the DMax function returns a Null. You can use the DMax function to specify criteria in the Criteria row of a query, in a calculated field expression in a query, or in the Update To row of an update query.
=DMax("[Freight]", "Orders", "[ShipRegion] = 'CA'")
Arguments
The following arguments are required:
Expr (String) - An expression that identifies the field for which you want to find the minimum or maximum value. It can be a string expression identifying a field in a table or query, or it can be an expression that performs calculation on data in that field. In expr, you can include the name of a field in a table, a control on a form, a constant, or a function. If expr includes a function, it can be either built-in or user-defined, but not another domain aggregate or SQL aggregate function.
Domain (String) - A string expression identifying the set of records that constitutes the domain. It can be a table name or a query name for a query that does not require a parameter.
Optional arguments
The following argument is optional
Criteria (String) - An optional string expression used to restrict the range of data on which the DMax function is performed. For example, criteria is often equivalent to the WHERE clause in an SQL expression, without the word WHERE. If criteria is omitted, the DMax function evaluates expr against the entire domain. Any field that is included in criteria must also be a field in domain; otherwise, the DMax function returns a Null.