Thank you sire once more for time, out of your busy schedule you took time out to answer my questions. one more sir!
I have this formula DCount("*","JSS2_QUERRY","MATHS >" & [MATHS])+1 which gives me this result output for the POSITION RANK column;
MATHS POSITION RANK 34 3 67 1 45 2 33 4
that has solved my problem, but I want to add suffix to the ranking positions like st for first as 1st, nd for second as 2nd, rd for third as 3rd, th for fourth as 4th etc, what do I need to add to the formula above? Thanks in anticipation!
Reply from Alex Hedley:
Yeo that works, there is a couple of Tips on Project Scoring that explained this further.
For the Ordinal/Suffix Rich answered this a long time ago on the Forum. Check out this thread.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.