Untitled

Recordset Error
Invalid use of group function
SELECT p.ProductKey, p.ProductName, Sum(t.TranQty) as SumQty, Sum(t.TranTotalPrice) as SumSales, Sum(t.TranTotalCost) as SumCost FROM products p, orders o, transactions t WHERE p.ProductKey=t.ProductKey and (t.TranModifier='R' or t.TranModifier IS NULL) and t.orderkey=o.orderkey and o.OrderDteTme BETWEEN '2007-03-18 00:00:00' AND '2007-03-24 23:59:00' GROUP BY p.ProductKey, p.ProductName ORDER BY Sum(t.TranQty) DESC, p.ProductName