how to store rank in a table

[RSethi]

I want to rank sales of a business by retail store within each region,state andcity. I want to store the rank in the column rank. How do I do this?

Table structure.
region, state, city, retailStore, sales, rank

[FishVal]

Hi, there.

The question doesn't make sense (for me at least).
How the "rank" is supposed to be calculated?

Kind regards,
Fish.

[nico5038]

For the approach check:

http://support.microsoft.com/support/kb/articles/Q208/9/46.ASP

Nic;o)