Return the minimum value from the result set of a query. (SQL).
Syntax Min (expression) Key expression A field or formula that evaluates to a numeric expression.
Use the Min function in the access query builder by clicking the Totals toolbar button:
The Min function is used in conjunction with the Group By clause.
Select Min(price) from T_Sales Group By Supplier;
“Winning takes talent; to repeat takes character.” ~ John Wooden
DMin - Return the minimum value from a set of records.
Avg (SQL) - Average
Count (SQL) - Count records
Max (SQL) - Return the maximum value from a query.
Partition (SQL) - Locate a number within a range.
Sum (SQL) - Add up the values in a query result set.
© Copyright SS64.com 1999-2013
Some rights reserved