Min, Max Functions (SQL Only)

See AlsovbfctSQLMinSee                 ExamplevbfctSQLMinEx>Low


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.

Argument        Description


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.