Query for Adding Duplicate Fields

[proberts]

I have a microsoft query that is pulling the following information. Most of the fields have duplicate product numbers with different unit numbers. I want to combine the duplicates while adding the unit numbers together.

Can anyone help me with this?

Ex:

Prod. # Unit #
123456 abcdef 666000
123456 abcdef 8033.71

I want it to read:
123456 abcdef 674,033.71

 

[dkinley]

Click the greek letter epsilon (E) on the query which will produce a Totals row.

Use the drop down box on the Totals row for each column. Group your product and sum the units.

-dK

 

[proberts]

Everything is calculating properly, thanks your your help.