Hello Pete666
Thanks for your relpy, I tried that but I need to give same rank to people with similar scores, What Iam looking for is the Access implementation of the "Rank" Function in Excel, I have read through threads with similar questions and tried out the suggestions, but fell flat...