Sort a Sum

[Ed Reed]

Is there any way to do the following? I get an error whenever I try this
(Invalid use of Group function).
 
Select Product, Sum(Qty)
>From Inventory
Group By Product
Order By Sum(Qty) DESC;
 
I want the total quantities for all products but I want to see the
products with the highest quantities first.
 
Thanks