Dmin

Return the minimum value from a specified set of records.

Syntax
      Dmin ( expression, domain, [criteria] )

      =DMin("[Field]", "Table", "[Field] = 'MyValue'")

Key
   expression The field to return.

   domain     The set of records, a table or a query name.

   criteria   Equivalent to an (optional) WHERE clause.
              Any field that is included in criteria must
              also be a field in domain.

For numerical criteria use "abc=Num"
for strings use "abc='string'"
for dates use "abc=#date#"

The DMin() function can be used in VBA or in an SQL query.

Examples

In a query:

In VBA:

Dmin("price", "T_Orders", "SupplierID = 64 ")

“If you are planning for a year, sow rice; if you are planning for a decade, plant trees; if you are planning for a lifetime, educate people” ~ Chinese Proverb

Related:

Min (SQL) - Return the minimum value from a query.