I have searched the board and saw the links the to MS site in regards to ranking...
I am unable to get those examples to work with my problem, so I turn to the experts here for some assistance.
I have a query that pulls in data from other queries.. I would like to rank the results within that query.
Query Example
ID Name exp1 exp2 exp3
1 Jo 12% 50% 60%
2 Sam 28% 47% 23%
Here is what I would like to happen
ID Name exp1 exp2 exp3 Rank1 Rank2 Rank3
1 Jo 12% 50% 60% 2 1 1
2 Sam 28% 47% 23% 1 2 2
Thanks in advance for any assistance with this
I am unable to get those examples to work with my problem, so I turn to the experts here for some assistance.
I have a query that pulls in data from other queries.. I would like to rank the results within that query.
Query Example
ID Name exp1 exp2 exp3
1 Jo 12% 50% 60%
2 Sam 28% 47% 23%
Here is what I would like to happen
ID Name exp1 exp2 exp3 Rank1 Rank2 Rank3
1 Jo 12% 50% 60% 2 1 1
2 Sam 28% 47% 23% 1 2 2
Thanks in advance for any assistance with this