I basically agree with Gregory, except that you should have each Student and score in a separate record
in the first place. See my article on normalization (
http://www.levelextreme.com/Magazine/August2002/Page7.asp).
HTH, Hilmar.
>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)