Total items based on criteria

[prodtest]

Hi
I'm struggling to build a report that I need,
Basically I have a query that shows all itmes shipped to customers between a certain date, what I need is a summary of this, The query is as below

Item Quantity
---- --------
68700D 2
68710 10
68705 3
68701 1
68700D 1
68705 5
68710 8
etc

I need this to be summarized as below:

Item Total Quantites
---- ---------------
68700D 3
68710 18
68705 8
68701 1

etc, basically giving me a summary of the longer list above
Any ideas ???

 

[DotNetGnat]

SELECT Item, Sum(quantity) From mytable
GROUP BY Item

-DNG