AnsweredAssumed Answered

How to sort and determine the position

Question asked by applezpiez on Mar 9, 2009
Latest reply on Mar 16, 2009 by TSGal

Title

How to sort and determine the position

Post

Hi,

 

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!

 

 

Outcomes