Combine Duplicate And Total

I need a report to print out from a form that combines like Items and then totals them. The report will not have the department field listed....

Here's an example:

Form:

Department---Product#---Type----Qty-Cost-- Total

Accounting---------i123 ----pen---- 2-- 1.00-- 2.00
Management--------a987 ----paper-- 3 --1.00-- 3.00
HouseKeeping-------i123 ----pen ----1 --1.00 --1.00
Shiping/Receiving---a987---- paper-- 4 --1.00 --4.00


What I need on report:
Product#---Type----Qty-Cost-- Total
i123-------- pen ----3 --1.00 --3.00
a987------- paper --7 --1.00 --7.00


Please help......