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.