Search results

Hi all, I am trying to figure out a transpose query in access; I have the below table: Name Score Rank Inna 4 1 Anna 5 2 George 2 1 And I would like to have something like the following; I have only two Ranks: Rank 1 and Rank 2 – these I would like to be my...

Hi, Correct, I have overlooked it, but still cant get the desired ranking. Any ideas how I may do this? Thanks

Hi all, I have the following issue that is causing me a headache for more than a week now. I need to rank the below entries: I have Table A incl the first two colums below(Name; Score) - I need to get column 3 in my result: Name Score Best Inna 2 1st best Inna 4 2nd best Luca...