I have a query that returns data such as:
(First row is field name, following are records)
strClass, strLastName, lngMonth, lngGrade
Biology, Douglas, 1, 90
Biology, Douglas, 2, 80
Biology, Kerk, 1, 88
Biology, Kerk, 2, 100
Math, Doe, 1, 80
Math, Doe, 2, 90
Math, Thomson, 1, 99
Math, Thomson, 2, 80
How can I get the query to return the records as:
strClass, strLastName, lngMonth=1, lngGrade, lngMonth=2,
lngGrade....etc
Biology, Douglas, 90, 80
Biology, Kerk, 88, 100
Math, Doe, 80, 90
....etc.
I've tried a cross-tab query, but can't get it to work without it
performing some sort of function (sum, count average) on the grades
data. Is the cross-tab the right idea? Or, is there a better way?
TIA!