Access Min. Return the minimum or maximum of a set of values contained in a specified field on a query. I thought it would be something like.
Min function works like max function but it will return the minimum value of the expression. Return the minimum or maximum of a set of values contained in a specified field on a query. It is designed to find the lowest value in the column passed as the only argument.
In this function a query will be passed as parameter and it will return the minimum record.
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. The min function returns the minimum value in a set of values. It is designed to find the lowest value in the column passed as the only argument. The microsoft access min function returns the minimum value in a set of numeric values in a select query.