Rank Ordering

[charlie123]

How do you Rank (ie: 1-10 based on sales volume high to low). I tried: RANK ([Sales Volume], 10, 0) but Access kept saying could not recognize RANK command. Suggestions?

 

[jebry]

Hi!

Try this:

Select Top 10 [Sales Volume] From YourTable Order By [Sales Volume] Desc

hth Jeff Bridgham
bridgham@purdue.edu

 

[tlbroadbent]

Simple case:

Select Top 10 ID, [Sales Volume]
From table
Order By [Sales Volume] Desc

Add a column to show rank:

Select Top 10 ID, [Sales Volume],
(Select Count(*) From table
Where [Sales Volume]>=[t].[Sales Volume]) As Rank
From table As t
Order By [Sales Volume] Desc
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.