Treating Query like Pivot Table

[thexxvi]

Good Morning,



I have data that keeps a record of each scored call that they make. Here's an example of what it looks like:


Name // Score 1 // Score 2 // Score 3 // Overall Score (Calculated Field that adds their 3 scores, divides them by 3 and gives a percentage)

Bob // 10 // 10 // 9 // 96.6 (1st call)
Kelly // 8 // 8 // 8 // 80.0 (1st call)
Carl // 9 // 8 // 10 // 90.0 (1st call)
Bob // 7 // 9 // 10 // 86.6 (2nd call)
Carl // 10 // 10 // 10 // 100.0 (2nd call)
Kelly // 6 // 10 // 10 // 86.6 (2nd call)

My question is that I want to run a query that scores everyone as a whole for all of their calls together. How would I do that? Ideally it would look like this:

Name // Overall Score (Calculated field for all of their scored calls)

Bob // 91.6
Kelly // 83.3
Carl // 95.0


Thank you,

Cory

[lfpm062010]

You can use "GROUP BY" and sum all their 3 scores and do the calculation on that.

[thexxvi]

Duh - That worked. Thank you!