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

sorting in a query

P: 12
I'm pretty sure the answer to this is simple, but i can't seem to be able to get it to work,

I am making a student database, I have a query with 3 fields, and basically i want to sort the data twice. I want to sort it for the students' class, and then i want to sort it by student name. So essentially the list of students will be grouped by class and then by name.

This must be possible, and probably really simple, i just can't get it to work!

Any help will be gratefully received

cheers all!
Mar 16 '07 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,366
You have to put class as the first field, sort by that, then put name as the second field and sort by that. Then you can have whatever fields you want after that.
Mar 16 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.