I have columns:
ID, Assigned to Primary, Assigned to Secondary, Assigned to Third, Assigned to Fourth, Assigned to Fifth, Assigned to Sixth, Assigned to Seventh. Primary Estimated Hours, Secondary Estimated hours, Third Estimated hours, Fourth Estimated Hours, Fifth Estimated Hours, Sixth Estimated Hours, and Seventh Estimated hours.
Primary Estimated hours is associated with Assigned to Primary
Secondary Estimated hours is associated with Assigned to Secondary
Third Estimated hours is associated with Assigned to Third
Fourth Estimated hours is associated with Assigned to Fourth
Fifth Estimated hours is associated with Assigned to Fifth
Sixth Estimated hours is associated with Assigned to Sixth
Seventh Estimated hours is associated with Assigned to Seventh
Each Assigned to position has a different employee assigned to with different estimated hours. Each Record (ID) can have up to 7 assignees with different names and estimated hours
How could I write a statement that looks at each record and calls out the record, the position, Employee name, and which estimated hours field is 0? Essentially I would like to look at folks who are assigned to a record but have not input any estimated hours.
Thank you very much for your time
