Min

Find the minimum value for a column or group.

Usage

Min(field)

field (required) The column to be searched. The function will search Numbers, Dates, and Strings, returning the minimum value.

NOTE: Sort order is affected by your database settings. For strings, sort order is most often blank spaces > special characters > numbers > uppercase letters > lowercase letters

For numbers, preceding and trailing zeroes most often have no effect on sort order.

Example

Min([Balance])
  • Finds the smallest balance. Could be negative.
Min([Name])
  • Finds the first name alphabetically. If Name was “Betty”, “Charles” and “Anne”, the result would be”Anne”
Min([Invoice Date])
  • Finds the lowest Invoice Date, which is the invoice date furthest in the past.

See Also

Was this article helpful?

Anything else?

Our customer support team is here to help.

Contact Us