I inherited a database used for grading. The person who created this set it up where the grader fills out a form, hits submit, and all of the data goes to a table. Among other info, the grader inputs the initials of who they're grading and a final letter grade (A,B,C,D). I'm trying to create a query that will return how many instances of each letter grade a person has.
An example of what I'm looking for with persons John Smith and Jane Doe:
JS A 15 B 7 C 2 D 1 JD A 17 B 6 C 3 D 0
Could anyone help me get started with this please? There's over a thousand entries and I'm not about to manually go through the data, but I'm new to Access and am still learning the program.