rayleventhal
Level 1

Employees and payroll

While I truly appreciate your efforts on my behalf, your steps get me close, but not to where I need to be.  

 

The final output must list one line per employee/date/job/hours.  Ex.  If John Smith worked on job MT01 for 8 hours on 1/1/20, there would be a single row with that data.  If he worked 4 hours on MT01 and 4 hours on XT01, there would be two lines for that date with his name, one for each job to which he applied 4 hours.

 

The redacted sample from the report I ran but didn't memorize shows a good example of what I need the report to look like.

 

Thanks again for your assistance.

 

Kind regards,

-Ray