Multiple Columns report

[marysilvaramos]

Hi:



I am trying to make a report like the attachment. The query fields are:

student id
Quarter (1,2,3,4)
Teacher
Subject
Percentage
grade
Comment
Effort
Conduct

Thanks very much in advance,

Mary

[June7]

If a CROSSTAB query won't accomplish what you need, options:
http://forums.aspfree.com/microsoft-...ry-322123.html
http://datapigtechnologies.com/flashfiles/crosstab.html