Rank - How can you Rank data in Access?

[yleeSF]

I need to Rank Sales Figures for a specified Period? Is their a function in ACCESS or an SQL statment that does this?

Thanks!

 

[mpastore]

You can use the TOP predicate. Look this up in help for examples.

Mike Pastore

Hats off to (Roy) Harper

 

[yleeSF]

Thanks for responding so quickly! I actually need to RANK sales figures by assigning a RANK to the store with the highest sales figure. For Example, assign a 1 to a store w/$100k in sales, 2 to a store w/$99k, and etc... for a certain period of time (Quarter One, etc...).

Can anyone help?

Thanks!

 

[MichaelRed]

In a report, you can generate a "running sum" field which is 'seeded' with the value "1". Set it to Sum "over all". To do it in a query is similar, however you need to be careful to reset it on each execution and you CANNOT place the results in a FORM -as scrolling through the records will continue to update the 'record counter'.


Do a search in these fora (Tek-Tips) for "Record Counter" and similar terms.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[yleeSF]

Thanks it worked perfectly!

YL