Dsum using an autonumber

[Callie]

I have a query from multiple tables where I want to calculate the sum of a
volume field (number) for all records with the same autonumber.

eg
ID (PK) Volume(number)
1 3.1
1 2.5
1 2.7
1 3.0
2 3.0
2 2.4
3 1.1
3 2.5

So the results I would like are; ID 1 = 11.3, ID 2=5.4, ID3=3.6

I have over 400 records so any help is much appreciated
Thanks in advance

 

[Duane Hookom]

Try:

SELECT ID, Sum(Volume) As VolSum
FROM [query from multiple tables]
GROUP BY ID;