__See Also__ __Example__

**Description**

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

**Syntax**

**Min(** *expr* **)**

**Max(** *expr* **)**

**Remarks**

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.