I would like to know how to
SUM up all the [Points] from the same person based on [PersonID]?
Example: Table Person has a full list of information for all the people. It has a column named [Points]. I would like this column [Points] to SUM/show all the points that belong to a person. The points can be found in another table for each event this person attended.
Table Event has the points listed based on [Person ID]. One [PersonID] can be found in multiple rows and each row represents the event he attended.
Example: [PersonID] is 1234 and [Points] 10 [PersonID] is 1122 and [Points] 10 [PersonID] is 2132 and [Points] 10 [PersonID] is 1234 and [Points] 10 [PersonID] is 1234 and [Points] 10
So [PersonID] 1234 has a total of 30 [Points] and I would like this 30 points shwo on the other table.
Does my explanation make sense to you? Thank you.
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |