Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2013

    Red face Unanswered: Ranking according to student average

    Hi There,
    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.
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2007
    Maitland NSW,Australia
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts