Examples of expressions that use the result of a domain aggregate function as criteria

Field Expression Description
Freight >(DStDev("[Freight]", "Orders") + DAvg("[Freight]", "Orders")) Uses the DAvg and DStDev functions to display all orders for which the freight cost rose above the mean plus the standard deviation for freight cost.
Quantity >DAvg("[Quantity]", "Order Details") Uses the DAvg function to display products ordered in quantities above the average order quantity.

For more information on using domain aggregate functions, click .