DSum Function Example

This example totals the values 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 = DSum("[Freight]", "Orders", "[Ship Country] = 'UK'")