I need to add quantities of items in a report. Table is structured as follows:
Products:
p_prodNo p_name p_category

p_prodNo = Product number.
p_category = Category.

ordDetail:
od_Qty od_prodNo

od_Qty = Quantity of item.


od_prodNo = Product number.

What I need to do is make a report that lists the products contained in ordDetail distinctly, with the total quantity of that product next to it; Grouping the whole thing by the product's category. Adding the quantity has got me stumped. Heres an example of the output I need: Quantity is to the left of the product name, product number is to the right. Anyone have any ideas?


Danish
----------------------------------
15 Cherry Danish 1704
12 Apple Danish 1632
9 Mini Danish 1743