I have a timecard database in which one record represents one day. I have separate tables for Employees (name, ID number, etc.) and Pay Period (start and end dates).
Every pay period (two weeks) I want to be able to generate a report for our payroll provider that will compile the daily records into a format organized by employee, and for only that pay period.
I am struggling to understand how reports work, and especially sub-summary parts. It looks like I will want to sort by the fields EmployeeID and PayPeriodEnd (each daily record will have this information associated with it).
I want the report to look something like this:
Employee ID Name
Pay Period End
Day 1 Regular Hours Overtime
Day 2 Regular Hours Overtime
Day 3 Regular Hours Overtime
Total Regular Hours for Pay Period Total Overtime Hours for Pay Period
I've created a report layout, but I have no idea how to get to what I'm trying to achieve.
Thank you for any help!