- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
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