counting

  • Thread starter Thread starter hermie
  • Start date Start date
H

hermie

Hello
I have a table with students names and the results of the tests done. From
this table I want to create a total by students with the total of results
I have 20 fields for the tests and the result of a test can be A, B, C, D or
F

The result of this query must look like:

Student A B C D F
mike 12 4 2 1 1
Carol 10 3 5 1 1

etc.
Anybody knows how to do?

Hermie
 
Back
Top