Adding of Fields in Different records

[pcliaros]

hi,

i've been trying to work out how to add a certain field with every record to add onto each other in a query. so for example,

ID-----Name-----Points


1 Name 1 53.31
1 Name 1 113.04
2 Name 2 72.7
3 Name 3 44
3 Name 3 272

into
ID-----Name-----Points
1 Name 1 166.35
2 Name 2 72.7
3 Name 3 316

what sql statement would i have to use to merge (i'm guessing) the fields with the same id, but add the points field?

much appreciated

[pcliaros]

did a bit of playing around and finally got it working:

SELECT tbl.ID, First(tbl.Name) AS FirstOfName, Sum(tbl.Points) AS AllPoints
FROM tbl
GROUP BY tbl.ID
ORDER BY Sum(tbl.Points) DESC;