Combining GROUP BY and SUM

[madhouse]

The image above shows results from a query I've created. However, I need to group the results by Product Id and display a sum of the individual Product Id's. So I should have something like:

Commercial Loan  Mr Steve F Cobblestone  LNCLCLRE   £299,491.33
Demand Deposit   Mr Steve F Cobblestone  DD033      £7,402.81
Demand Deposit   Mr Steve F Cobblestone  DD043      £3,929.78
Time Deposit     Mr Steve F Cobblestone  TD013      £12,195.60
Time Deposit     Mr Steve F Cobblestone  TD018      £961,924.12
Time Deposit     Mr Steve F Cobblestone  TD025      £113,483.58

Any ideas how I construct a query to display the results as per above??

 

[RV]

How 'bout summing on Balance and group on your other columns.....

RV