DMin, DMax Functions Example

This example returns the lowest and highest value from the Freight field for orders shipped to the United Kingdom.  The domain is an Orders table.  The criteria argument restricts the data by making the expression apply only to records in which Ship Country equals UK.

X = DMin("[Freight]", "Orders", "[Ship Country] = 'UK'")

Y = DMax("[Freight]", "Orders", "[Ship Country] = 'UK'")