Min, Max Functions

See Also    Example

Return the minimum or maximum of a set of values contained in a specified field on a query.

Syntax

Min( expr )

Max( expr )

The expr placeholder represents 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 expr 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).

Remarks

Use Min and Max to determine the smallest and largest values in a field based on the specified aggregation, or grouping. For example, you could use these functions to return the lowest and highest freight cost. If there is no aggregation specified, then the entire table is used.

Use Min and Max in a query expression and in the SQL property of a CdbQueryDef object or when creating a CdbRecordset object based on an SQL query.