Rank Records Based on Value

[Bonediggler]

Hi There--

I am wondering how you would assign ranks to records based on their values--i.e. the record with the highest value gets 1, the record with the second highest value gets 2, etc.

Ultimately I need a query that will have 5 original fields and 5 calculated fields which contain rankings for the records in the original fields.


Thank you~

 

[MajP]

something like?

SELECT A.intValue, Count(A.intValue) AS CountOfintValue
FROM tblTable AS A, tblTable AS B
WHERE (([A].[intvalue]>[b].[intvalue] Or [A].[intvalue]=[b].[intvalue]))
GROUP BY A.intValue
ORDER BY A.intValue;