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 |