By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,054 Members | 1,304 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,054 IT Pros & Developers. It's quick & easy.

Q: Sorting/Grouping query results

P: n/a
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!
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Stock answer. Read the following article:

http://www.mvps.org/access/modules/mdl0004.htm
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.