SELECT ProductName, Product_Id, DeliveryDate, SUM(Quantity), UnitPrice FROM customer_order GROUP BY Product_Id, Month(DeliveryDate) ORDER BY DeliveryDate; in fact your sql syntax can not compile. a correct one is like this Code: SELECT ProductName, Product_Id, DeliveryDate, SUM(Quantity), UnitPrice FROM customer_order GROUP BY ProductName, Product_Id, DeliveryDate, UnitPrice ORDER BY DeliveryDate;you can adjust your sql as need like above Hope to help you. Post edited by: Cheng.Ken, at: 2007/06/26 01:06