1 Reply Latest reply on Oct 24, 2014 7:02 AM by philmodjunk

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

    director@charlesmoore.org

      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