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!

how are you going to break the tie then?

just build that into whatever ranking function you are using

i break ties by adding a very small random number, like 0.00001, which doesn't affect that absolute ranking base

regards

sportsguy