I need to run checks on data for accuracy. I’m getting conflicting figures so at this stage I’m convinced it’s my logic that’s the problem and I could do with a bit of help.
I have two tables. One is Employees with a field that is a list of Courses they have attended.
The second table is a list of Courses with a field that is a list of Employees who attended.
I do a Do a Search for Employees with constraint Courses is empty and get a result X.
Then I Do a Search for Employees:filtered Uniquie ID isn’t in Do a Search for Courses Employee’s Unique ID and get a result Y.
The problem is that X + Y are not equal. So where am I going wrong?