Please provide the total of the “Quantity” column from the “OrderDetails” table.
| SELECT Sum(Quantity) AS TotalItemsOrdered FROM OrderDetails; |
The SUM() function computes the total of a given set of values, disregarding any NULL values.
| Sum(expression) |
|
Parameter |
Description |
|
expression |
Required. A field or a formula is necessary as an argument for the |
|
WORKS IN |
From Access 2000 |