I have a table that is a line item table it has the following fields
As the employee fill in the daily report they will have several labor functions performed that day.
6/24/13 Sweep 2 Hrs.
6/24/13 Dust 3 Hrs.
6/24/13 Vacuum 1.25 Hrs.
6/24/13 Etc. 2 Hrs.
All of these functions were done on 6/24/13
All of these are within the same table just different line items,
Now comes payroll time and I need create a report that shows the daily hours summarized between a start date and end date
I would like to show each day individually with the hours worked that day but not all the lines for that day just the summary.
Per employee, so each employee would have there own piece of paper with only their info on it.
I guess what I am have trouble getting my mind around is the sort between dates by employee and then summarize the the daily amounts.
Any thoughts would be appreciated
Thanks in advance