Works like a champ!

Thanks!

Of course it would be that simple!

Almost perfect.

When the employee does have 2 term records, it of course now returns both records. How would I further filter those to...

How can I include duplicate data only if certain criteria are met?

Employee table. If employee moves from one company to the other, the employee is terminated in the old...