i want to prepare a query which gives me the ranking of the classroom according to their average. (also there are classrooms in the table, if possible, query should consider the grades) you can see the attached sample document. thank you for your help.
Have a look at this site ACC2000: How to Rank Records Within a QueryYou will need a query for each Grade to RANK the students within the grade. If you want to show the RANKINGS for each grade as one report etc. you will need to create an UNION query to join each grade query.