4 Replies Latest reply: May 23, 2013 6:31 AM by Mohit Sharma RSS

    Select in field: How to use Search String?

      I have something which looks like the below at the moment:

      http://imgur.com/tIz0SD3

       

       

       

      In English I would like to select the field "c_Cinema" which has the minimum "d_DistanceApart_Miles"

       

      c_Cinema is a string, d_DistanceApart_Miles is an int.

       

      Data would look like so

       

      Cinema 1    -    1 miles

      Cinema 1   -     1.5 miles

      Cinema 2   -     4 miles

      Cinema 2    -   4.5 miles

       

      etc...

       

      Could anyone help me out?