QUERY OR FUNCTION TO RANK TOTAL MARKS AUTOMATICALLY AS THEY ARE ENTERED (1 Viewer)

[mercystone]

Hello everyone. I am trying to rank the Students based on the total marks of the subjects being entered. Kindly check attached database. Somebody to help me with a function or query to rank total marks of Students. Kindly check Student Examination Details (from subform). Thanks in advance. God bless

 

[Pat Hartman]

Ranking isn't done until ALL the data is entered. Otherwise, you have to rank after each entry which is really inefficient.

What is wrong with the solution arnel created for you in your other thread which you marked solved?

Solved - QUERY OR FUNCTION TO RANK

Hello everyone. I am humbly and kindly requesting for somebody to assist me rank the subjects in the description in the attached database. The query or function should rank subjects automatically as the mark is being entered for students. E.g student A ENGLISH 60, STUDENT B ENGLISH 70, Student C...

www.access-programmers.co.uk

 

[mercystone]

Ranking isn't done until ALL the data is entered. Otherwise, you have to rank after each entry which is really inefficient.

What is wrong with the solution arnel created for you in your other thread which you marked solved?

Solved - QUERY OR FUNCTION TO RANK

Hello everyone. I am humbly and kindly requesting for somebody to assist me rank the subjects in the description in the attached database. The query or function should rank subjects automatically as the mark is being entered for students. E.g student A ENGLISH 60, STUDENT B ENGLISH 70, Student C...

www.access-programmers.co.uk

That was for subjects only. I need the totals for subjects

 

[mercystone]

Ranking isn't done until ALL the data is entered. Otherwise, you have to rank after each entry which is really inefficient.

What is wrong with the solution arnel created for you in your other thread which you marked solved?

Solved - QUERY OR FUNCTION TO RANK

Hello everyone. I am humbly and kindly requesting for somebody to assist me rank the subjects in the description in the attached database. The query or function should rank subjects automatically as the mark is being entered for students. E.g student A ENGLISH 60, STUDENT B ENGLISH 70, Student C...

www.access-programmers.co.uk

Rank totals for subjects please. Thanks in advance

 

[Eugene-LS]

Rank totals for subjects please.

May be that way:

SELECT [First Name] & (" "+[Last Name]) AS [Studen Name], Sum(StudentSubjects.Mark) AS [Sum of Mark], Subjects.[Subject ID], Subjects.Description
FROM Subjects RIGHT JOIN (Students INNER JOIN StudentSubjects ON Students.ID = StudentSubjects.StudentID) ON Subjects.ID = StudentSubjects.SubjectID
GROUP BY [First Name] & (" "+[Last Name]), Subjects.[Subject ID], Subjects.Description
ORDER BY Sum(StudentSubjects.Mark) DESC;