AnsweredAssumed Answered

Summary by Dates

Question asked by Jason_Farnsworth on Jul 11, 2013
Latest reply on Jul 17, 2013 by stephensexton

I have a table that is a line item table it has the following fields

 

Employee

Job Number

Labor Department

Labor Function

Labor Type

Date

Hours

 

As the employee fill in the daily report they will have several labor functions performed that day.

 

Example:

 

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

 

Jason Farnsworth

Midland, Tx

Outcomes