AnsweredAssumed Answered

Finding duplicates in multiple fields

Question asked by CraigFiore on Jan 18, 2012
Latest reply on Jan 18, 2012 by 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

Outcomes