Calculating the sum of specific fields where the ID= the same value.

[oakhoplite]

Hi! I am quite new to Access and I am trying to create a query that calculates the sum of some fields for which the ID=the same value. For example, if I have a table that contains the scores obtained by skaters for each move that has appeared in their performance.

SkaterID	MoveID	Score (for that move)
1	4	11
1	5	12
2	8	9
2	9	8

And I want a query that displays the SkaterID and the TotalScore for their performance (the total score is equal to the sum of the scores - for that skater). So the sum of the scores for which the SkaterID is the same so that I get a datasheet that looks like this:

SkaterID	TotalScore
1	23
2	17

I am sorry if the explanation was very unclear! Help would be greatly appreaciated!

[isladogs]

You need to create an aggregate query.
In query design view, add the 2 fields SkaterID and Score.
In the ribbon click the Totals button -Greek letter Sigma
An extra totals row appears in your query with both fields showing Group By.
Change that to Sum for the Score field.
Run the query and it should look similar to what you want except it will say SumOfScore.
If you want TotalScore change the Score field to TotalScore:Score in the field Name row