2 Replies Latest reply on Jan 18, 2012 2:33 PM by CraigFiore

    Finding duplicates in multiple fields

    CraigFiore

      Title

      Finding duplicates in multiple fields

      Post

      I am trying to find duplicates that are in multiple fields. He is my situation:

      I have three fields:

      EmployeeID

      JobID

      Date

       

      I am trying to find out if an employee has a record for the same job on the same day. So I want to find out if there are two or more entries that equal 

      Employee ID-JS1

      JobID-12-001

      Date- 1/5/12

       

      Is this possible? I am assuming I will need to wright a script.

       

      Thanks