AnsweredAssumed Answered

Does anyone know how to create “self-adjusting” ranks in a database? I have records tha...

Question asked by director@charlesmoore.org on Oct 24, 2014
Latest reply on Oct 24, 2014 by philmodjunk

Post

Does anyone know how to create “self-adjusting” ranks in a database?
 
I have records that each represent a PLACE in a city.
 
I need to rank places within each city.
 
So
 
PLACE 10 = 1
PLACE 5 = 2
PLACE 16 = 3
PLACE 40 = 4
PLACE 100 = 5
 
BUT if I create a new record, say
 
PLACE 22 = 3
 
Then all the other formerly ranked places should self adjust.
 
SO  
 
PLACE 10 = 1
PLACE 5 = 2
PLACE 22 = 3
PLACE 16 = 4
PLACE 40 = 5
PLACE 100 = 6
 
 

Outcomes