Microsoft Access help?

[javasaurus]

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?

Comments

Quizes 1-50

[(Anonymous)]

It sounds like you're gearing up to teach again.

Orkney Lover

Re: Quizes 1-50

[javasaurus.livejournal.com]

Not really. I'm using the names and quiz scores as a simple example of what I want to do. What I'm actually doing is related more to my job.

[thewhitedragon.livejournal.com]

If I had... ya know... some free time, I'd tell you to email it to me and I'd try and figure out what you're trying to do since I wrote several Access db's for former companies.

Unfortunately, my head is currently set on the 'explode' setting and free time is something that I'd run out of. Grrr...

[javasaurus.livejournal.com]

That's okay. I've taken drastic measures. I've pulled out the manual...

[thewhitedragon.livejournal.com]

ouch. last resort time.