Who didn't take the class?

[oboo54]

I have created a small database designed to track classes each ahs complted or not. I can generate a report to list the classes completed by a student, but I can't seem to generate a report not taken by a student. I'll be more than happy to e-mail this small program to anyone who can help me fix this problem.

Thanks in advance

Oboo54

 

[Hayley Baxter]

I'm happy to take a look at it for you. You can zip the db and post it here.

 

[stormin_norm]

I created a similar report of a grade sheet for a semester where all students need to be listed. Some students already had a grade, others did not. Naturally, When they did NOT have a grade for a course, there were no rows stored in the database.

To produce the report I used a query for getting the initial set of all students & grades and then used a crosstab query to transpose the data.

Would something like this work? You can always email me the db (zipp'd)

-norm.