Full Class Subject Wise Result

[Pac-Man]

Hi all,

I want to create subject wise result of full class of student so that first 2 columns contain names of student, next 6 or 8 (no may change with class) columns contain subject names in header and obtained marks by each student in detail section, then next 3 columns for total marks, percentage and grades. How can I do that.

I tried using cross tab query but it don't work if subject names or no of subjects is changed.

TIA
Best Regards
Abdullah

 

[theDBguy]

Hi. Can you post a sample db with test data, so we can see what you mean?

 

[Pac-Man]

Hi. Can you post a sample db with test data, so we can see what you mean?

Hi @theDBguy,

Thanks for reply. Yeah sure, please see the attached file. In the cross tab query, you can see ClassID is set to 5 (class which contain 8 subjects) and you can switch it to ClassID = 3 for the class which contain 6 subject. rptClassResult is the report which I want to create for whole class. When you switch the ClassID to 3, rpt gives error.

Best Regards