loveyoursite
Technical User
CRV10. I have a report that needs to show employees with more than one position, i.e. Level 1, Level 2, Level 4.
If an employee has more than 1 position, then all of the positions must be listed. I'm not sure how to exclude those employees who have ONLY 1 position. For example:
Include employees with more than 1 position:
J. Brown, Pos Level 1, Painter
J. Brown, Pos Level 2, Contractor
J. Brown, Pos Level 5, Engineer
Exclude employees who have ONLY 1 position, which would always be a Level 1:
B. Green, Pos Level 1, Painter
I would appreciate any assistance. Thanks!
If an employee has more than 1 position, then all of the positions must be listed. I'm not sure how to exclude those employees who have ONLY 1 position. For example:
Include employees with more than 1 position:
J. Brown, Pos Level 1, Painter
J. Brown, Pos Level 2, Contractor
J. Brown, Pos Level 5, Engineer
Exclude employees who have ONLY 1 position, which would always be a Level 1:
B. Green, Pos Level 1, Painter
I would appreciate any assistance. Thanks!