ranking in query / without table field

[deviation]

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