Marking records with matching data... use duplicates??
So... I have records that track data that for the sake of simplicity I'll call: JOB NUMBER, DATE, TIME START, TIME END, and VEHICLE. In this setting it is possible two have two or more jobs logged with the date, times and vehicle... doing 2 jobs at the same time. I'm trying to find a way to go back through all 5000 or so records, find the ones where two or more jobs are done at the same time and mark another field, say MULTIPLE JOB as "Y".
I've been trying to use the "!" search operator (then just backfill the MULTIPLE JOB field using REPLACE FIELD CONTENTS), but I don't think I'm using it right.