G
Guest
Is there any way to take one Main table(contains a bunch of stuff, but I'm
just concerned with the names column), compare it to a secondary table with a
list of employees and then show on the main table the names that didn't
appear on the main table?
-
For example if the main table has:
John
Jim
Paul
-
And the employee list table has:
John
Jim
Paul
Andy
Cody
-
I'm trying to show on the report that Andy and Cody were not present.
Is this even possible?
Thanks!
just concerned with the names column), compare it to a secondary table with a
list of employees and then show on the main table the names that didn't
appear on the main table?
-
For example if the main table has:
John
Jim
Paul
-
And the employee list table has:
John
Jim
Paul
Andy
Cody
-
I'm trying to show on the report that Andy and Cody were not present.
Is this even possible?
Thanks!