8 Replies Latest reply: Aug 18, 2011 1:56 PM by Therese Liebermann RSS

    Selecting a range over two fields?

      Hi,

       

      I have two fields - LowFreq and HighFreq.  I want to be able to select all the records that are in a certain range, let's call them l_freq and u_freq.  i can set up a select string that will search over the LowFreq, but I need to be able to select the range.  Meaning - it should select record that has a LowFreq that is lower than l_freq, but has a HighFreq that is higher than l_freq.  The table below gives a better explanation on items that need to be selected.

       

       

      if the frequency range that I want to select is 7-25, then the highlighted records should be selected.

       

      Record IDLowFreqHighFreq
      11020
      225
      3212
      41732
      53035
      6250

       

      Is there a way to do that?

       

      Thanks in advance!

      Therese