[AccessD] New SQL Question

Martin Reid mwp.reid at qub.ac.uk
Wed Mar 31 04:15:31 CST 2004


Heres the record

ID    2003001
A        12.9
B        15.4
C1       12.5
D1        10
C2       Null
D2        12.9

Given the above how do I get a count for ID 2003001 of 5 indicating that the
student sat 5 exams out of the possible 6.

The Null indicates that the student did not sit that exam.

Not my DB and I cant change anything re structure etc

Martin




More information about the AccessD mailing list