Stumped on how to create this Report (1 Viewer)

[weilerdo]

Hi Everyone,

I have 1 last report to finish this database that I have been working on and can't seem to get my head around how to do this. I have a table tbl_transcripts that has 6 fields in it. [student], [subject], [class],[date_comp], [credit] and [comp] and "comp" is a yes/no field. I need to create a report that is by[student], and grouped by [subject] which is the easy part I know, the problem is that I need it to look like the attached report. As the classes are differnet for each student I can't just do labels, one student might only have 2 classes under 1 subject and another might have 4. I hope what I have described makes sense. I really am stumped on this one. Any help on this one would be so appreciated.

 

[jdraw]

Which "labels" exactly are you talking about?

 

[weilerdo]

Like in the attachment I created labels for requided credits, subject and orginallly I thought that all of the classes would be the same. IE student 1 and student 2 both would take English 1 and then English 2, etc but now I find that student 2 might take AP English instead of English 2