Calculated field in a table based on values from another table

[oakhoplite]

Hi! I am new to working in access and I would like to create a calculated field in a table based on values from another table. I have a table that shows the performance of a skater (the skaterID, the moveID and the score-which is the number of points obtained on that move). The table looks like this:

SkaterID	MoveID	Score
1	8	8
1	9	12
2	5	4
2	1	13

And I would like to create a table that contains the SkaterID and the TotalScore (which is the sum of the scores for a specific skater). So for each skater, I need to calculate the total score and the table would look like this:

SkaterID	TotalScore
1	20
2	17

The TotalScore is the calculated field, however, I do not know what I should write as its formula in order to obtain those results. Help would be greatly appreaciated!

[pbaldy]

I don't think a calculated field can use values from another table, but a simple totals query will give you that result.

SELECT SkaterID, Sum(Score) As TotalScore
FROM TableName
GROUP BY SkaterID