2 Replies Latest reply on Apr 5, 2016 1:22 AM by Jon Gordon

    Join a set of values with a range where they fit

    Michael Lance



      I have 2 tables.

      The first has set of scaled scores.

      The second has a set of ranges for the scores and, for each range, an associated objective.

      Like this (2nd table):


      Range               Objective

      2000-2190          Dividing Fractions

      2191-3245          Dividing Mixed Numbers





      I want to create a view that associates each particular score with the objective via the range in which the score falls.


      So if a score was 2100, the associated objective would be "dividing fractions."



      Any ideas?