Cao Thanh Trung

[Cao Thanh Trung]

I need to sort a table and assign a score to the first place (fastest time).
The first place would be a value of 1 and slower times would be 2, 3, 4,
etc.
I then need to record the time and this new value to compile a rank score.
Is
there an easy way?

Here is what I want:

876543 2.45 1
234564 2.876 2
654789 3.56 3

This would be for test one. There are a total of 15 tests. A student may not
always be first but we need to find his total rank score.

654789 2.45 1
234564 2.876 2
876543 3.56 3

Here is the results for test two

Here are the rank scoring for all three

876543 1 + 3 = 4
234564 2 + 2 = 4
654789 3 + 1 = 4

This is the way the district is scoring a test we give every year and I am
hoping I do not have to hand calculate the rank score by hand anymore. I can
get the sorting to show me the order but with 15 tests and as many as 300
students there is just a lot of hand work.

 

[MGFoster]

See this site for an explanation of how to rank query results:

http://support.microsoft.com/default.aspx?scid=kb;en-us;120608

Note: Put a more descriptive Subject on your next posts.