Here's my quandry, maybe you can point me in the right direction.

I have a record in a table with up to 6 personnel names and test scores associated with each name meaning 6 people took the test at the same time and the results were recorded in one record.

The table has multiple records like this and the 6 personnel names may or may not be the same from record to record and may appear in any one of the 6 positions.

For example -
Record 1
Joe Smith 95 75 90 Mary Jones 80 85 90 John Doe 95 95 100 up to 6 names.
Record 2
Todd Williams 75 85 95 Jimmy Wilson 65 80 90 Joe Smith 100 95 100 up to 6 names.

I have a second table with names of all students in it. How should I approach writing a program that compiles a summary of test scores for all students?

I have started and stopped a couple of approaches, but am debating which way to go. Thanks for some guidance and direction.