Grading

[wilberato]

Hi Guys I need help in using the rank function.
I have a table with the following fields but would like to rank the students according to their total scores. How do I do it.

Name Score 1 Score 2 Score 3 TotalScore Position



How do I rank the students in a query. Help

I want to store the ranks in the field called Position.

[bartonc]

Hi Guys I need help in using the rank function.
I have a table with the following fields but would like to rank the students according to their total scores. How do I do it.

Name Score 1 Score 2 Score 3 TotalScore Position



How do I rank the students in a query. Help

I want to store the ranks in the field called Position.

That will depend completely on which software development tools/programming language that you are using. There a many database development help forums under the "Forums" tab, above.

Thanks for joining.