How to sort and determine the position
I am now creating a points system, such as every week the teacher will enter the points the students earned.
Example (my student point database):
Jan - Week 1 - Peter - 1 pts
Jan - Week 1 - Mary - 2 pts
Jan - Week 2 - Peter - 3 pts
Jan - Week 2 - Mary - 4 pts
Jan - Week 3 - Peter - 5 pts
Jan - Week 3 - Mary - 6 pts
Jan - Week 4 - Peter - 7 pts
Jan - Week 4 - Mary - 8 pts
Then i will use a summary field to get the total points earned for one month,
hence i will get:
Peter - 16 pts
Mary - 20 pts
Hope you still understand so far..
Next, i will need to determine the position of the students based on the points they earned in each month. In this case, Mary got 1st, Peter got 2nd and etc (for the rest of the students)
I need to prepare the report as shown below:
Month - 1st - 2nd and etc...
Jan - Mary - Peter and etc....
Feb - .................................
This is where i am lost... Not sure how to sort and determine the position. Please advise.
Thanks in advance!