View My Drafts
James I suspect you are correct. there are 600,00+ rows, and I would not expect any missing data in the field I am using, assigned_to_name.
However I just learned last night that when an employee leaves the company, they change the employees id. AND that the software does not "hold" the original data, but is actually a connection to a name table so the field assigned_to_name is then updated for all prior records.And the updated name for the now gone employee does not contain a "("
I am testing this today and will update this thread when I know the answer.