Group and Sum

[m82palmer]

Hopefully a simple Query / SQL problem


I have a query that returns:

id Weight EXP1(weight * 2)
-------------------------------
1 12 24
1 05 10
1 02 04
2 10 20
3 05 10
3 02 04
4 10 20


Is there a easy way to group the IDs together and do a sum of the EXP1(weight * 2), thus getting:

id EXP1(weight * 2)
-----------------------
1 38
2 20
3 13
4 20


Cheers

Michael

 

[Brianwarnock]

Use a Totals query, ∑ on the toolbar, Group by on ID and Sum EXP1

Brian