Hello everyone,
I was wondering if anyone can help me solve the following issue?
I've set up a ranking field according to the MS Access help site and it ranks everyone in order, just the way it's suposed to. However, whenever there is a tie or several people with the same score, it lists them all with the same number. Whereas, if several people have the same score, for example, in the fourth position, it will list them as:
1.
2.
4.
4.
4.
6.
7.
8.
I was wondering if anyone new a formula, or a way to resolve this, so that it will rank them in order without any ties?
I know that I read a way to do it somewhere before, but I can't seem to locate the procedure online.
Thanks for your help!
I was wondering if anyone can help me solve the following issue?
I've set up a ranking field according to the MS Access help site and it ranks everyone in order, just the way it's suposed to. However, whenever there is a tie or several people with the same score, it lists them all with the same number. Whereas, if several people have the same score, for example, in the fourth position, it will list them as:
1.
2.
4.
4.
4.
6.
7.
8.
I was wondering if anyone new a formula, or a way to resolve this, so that it will rank them in order without any ties?
I know that I read a way to do it somewhere before, but I can't seem to locate the procedure online.
Thanks for your help!