AnsweredAssumed Answered

Marking records with matching data... use duplicates??

Question asked by FMNewbie on Apr 14, 2012
Latest reply on Apr 14, 2012 by GuyStevens

Title

Marking records with matching data... use duplicates??

Post

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. 

What am I missing?  Do I need to do this through a script or something???   Help?  Yell

Outcomes