Microsoft Access help?

Suppose you have a table in Access with the fields "Name", "quiz 1", "quiz 2", and so on through "quiz 50"

The recordes include student names and their scores for the quizes.

What I want to do is, for each student, provide a list of quizes that he failed. A simple report might look like:

***************************************
John Doe
quiz 7, quiz 9, quiz 23, quiz 42

Jane Smith
quiz 7, quiz 10, quiz 23, quiz 49

Jack Jackson
quiz 7, quiz 25, quiz 46
***************************************

This might be easy if the student names were the fields and the quizes were the records, but the database uses student names as the primary field for other reasons.

Any ideas?

vocabulary for the day

The dot over the letter I or j is called a "tittle."

A similar word, "diaeresis," is a pair of dots over a vowel, indicating that it is pronounced separately from the preceding vowel, rather than as a dipthong (e.g., naïve). It looks like the German umlaut, but is used differently.

Marks such as the tittle and diaeresis and various similar marks and accents are collectively called "diacritics" or "diacritical marks."

Mmmmm....Tea....

Just wanted to point out that I love the boiling water tap that we have here at work. Just toss a tea bag into a mug, add nearly boiling water, and in three minutes, wa-la! tea!

Today I'm drinking Trader Joe's Jasmine Green Tea.

Mmmmm....