AnsweredAssumed Answered

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

Question asked by dwin on Nov 25, 2013
Latest reply on Nov 25, 2013 by philmodjunk

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 

Outcomes