Min, Max Functions (SQL Only)
See Also Example
Return the minimum or maximum of a set of values contained in a specified field on a query.
Min( expr )
Max( expr )
The Min and Max functions use the following argument.
expr String expression identifying the field that contains 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, or a Visual Basic function (which can be intrinsic but not a user-defined function or one of the other domain aggregate or SQL aggregate functions).
You can use Min and Max to determine the smallest and largest values in a field, including a Text field. For example, you could use Min and Max to return the lowest and highest freight cost.
You can use Min and Max in a query expression.