Sum Function (SQL Only)
See Also Example
Returns the sum of a set of values contained in a specified field on a query.
Sum( expr )
The Sum function uses the following argument.
expr String expression identifying the field that contains the numeric data you want to add, or an expression that performs a calculation using the data in that field. Operands in expr can include the name of a table field, a control on a form, a constant, or a function (which can be either intrinsic but not a user-defined function or one of the other SQL aggregate or domain aggregate functions).
Sum totals the values in a field. For example, you can use Sum to determine the total cost of freight charges.
The Sum function treats records that contain Null fields as having a value of 0. The following example shows how you can calculate the sum of the Order Amount and Freight fields.
SELECT Sum([Order Amount] + [Freight]) FROM Orders