Grouping and ranking in Ms Access 2007

[kimmutua]

May someone help me to group the data in the exam xtended query according to the student level and also guide me to rank the students according to Total marks in descending order

Exam xtended Query
Student Name	Level	Term	Total Marks
jane mutuku	Form 2	one	600
Mutua Kimanthi	Form1	one	556
Musembi Maitha	Form 3	one	544
Maitha kim	Form 3	one	700

[June7]

Have you tried building a report using Grouping & Sorting features?

[AlexHedley]

Hi,

You can find a FREE Tip at http://599cd.com/tips/access/report-sorting-grouping/

If you want to Order By Total Marks just create a Query then pull in the TotalMarks Field and in the Sort: row add Descending.

If you want to Group By Level pull in the Level Field, turn on the Totals (Σ) and Group By Level and Sum by TotalMarks.



SQL
SELECT Exam_xtended_Table.Level, Sum(Exam_xtended_Table.TotalMarks) AS SumOfTotalMarks
FROM Exam_xtended_Table
GROUP BY Exam_xtended_Table.Level
ORDER BY Sum(Exam_xtended_Table.TotalMarks) DESC;



Sorting
Access Beginner 1 [http://599cd.com/site/courselist/access2010/beginner/b1/]
Access Expert 3 [http://599cd.com/site/courselist/access2010/expert/x3/]

[kimmutua]

ok thanks for the help tip u just helped me alot