2 Replies Latest reply on Nov 25, 2013 10:19 PM by philmodjunk

    Trying to do a find where 2 fields are equal across records

    dwin

      Title

      Trying to do a find where 2 fields are equal across records

      Post

           I am trying to do a find where records have two fields that are equal. I have a transaction file where I have a unique customer ID field and a date of transaction field. I want to find all the records where for each record those two fields were matched in another record. 

           Record 1: ID 45  Date 11/11/12

           Record 2: ID 45  Date 11/11/12

           Thanks