rank

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

Is there a function in Access '97 that does the same thing
as the Rank() function in MS Excel? I want to take a list
of numbers and rank them relative to each other. I
figured if you could do this in Excel, you could do it in
Access. If anyone can help, it would be appreciated.
Thanks...

Craig
 
Craig said:
Is there a function in Access '97 that does the same thing
as the Rank() function in MS Excel? I want to take a list
of numbers and rank them relative to each other. I
figured if you could do this in Excel, you could do it in
Access.
Click to expand...


In a database system, queries are the normal way of dealing
with data. A spreadsheet function doesn't really apply
since there's no range of cells to operate on.

Here's a simple query that includes a ranking subquery:

SELECT table.person, table.score, . . .
(SELECT Count(*)
FROM table As X
WHERE X.score <= table.score
) As Rank
FROM table
 
Back
Top