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

      Hello.

       

      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?

       

      Thanks,

      Michael