Grouping Duplicates

[Meking]

I need to create a report that groups duplicates and totals the quantity.

Here's an example:

Current Report:

Product# Type Qty Cost Total

i123 pen 2 1.00 2.00
a987 paper 3 1.00 3.00
i123 pen 1 1.00 1.00
a987 paper 4 1.00 4.00


What I need:

i123 pen 3 1.00 3.00
a987 paper 7 1.00 7.00


Please help......

 

[Moniker]

Group By Product# and Type.

Sum by Qty, Cost and Total.

To do this, open a new query, attach the table with those fields on it, click the Sigma to turn on aggregate queries, change the "Total" row to Group By for Product# and Type, and change "Total" to Sum for Qty, Cost, and Total.

 

[Meking]

Thank you very much, that makes a lot of sense. I'll try to put it together now.....