2 Replies Latest reply on Nov 17, 2010 11:25 AM by HB

    find records having equal values in 2 different fields

    HB

      Title

      find records having equal values in 2 different fields

      Post

      How can I find records having equal values in 2 different specified fields?

      ie show all records where field1 = field2

      I thought it would be easy.

      I seached everywhere.

      I tried the find 

      ::field1=::field2

      but it thinks the ::field2 is just text!

      thanks in advance