add a field in a report in Access that declares positions availed by students (1 Viewer)

jamilmurad

New member
Local time
Today, 14:46
Joined
Oct 24, 2012
Messages
9
add a field in a query/report in Access that declares positions availed by students

assalam o alaikum all.
I have designed a database in Access for our college. the database contains results of the students. collective result of the entire class is displayed in a report that is based on a query. the problem is that we are declaring the positions of the students in the results manually. I am using a query to get students personal, academic and result details from different tables such as;
StudentId and Name from Students, Class from Classes, Session from Sessions, English, Urdu, Computer, General Science, Histoty, Islamiat, Mathematics from Results and Result, Percentage and Grade as calculated fields in the query.
Now plz guide me how to rank the results using the query or directly on a report, if more than one students have equal obtained marks then they should be treated same positions.

Regards
 
Last edited:

Users who are viewing this thread

Top Bottom