G
Guest
So I am attempting to find a solution to a sorting and reporting issue. I
have a table that I have that has the names and times that people have
worked.
Simple in format.
Date, Employee Name, Hrs worked , Location worked
So what I want to do is sort this info so that if first takes each employee
and adds there time up and on the report it states the employee name and
hours worked.
EG.
Name Events Total Hrs
Fred Smith 11 32.5
For those employees that are over 40 hrs I need to have a modified output.
I need to list the events that they worked and sort the events by Location
Worked so it should look like this :
Name Date Location Hrs
Fred Smith Jan 12 2007 Harper Drive 8
Fred Smith Jan 13 2007 Harper Drive 10
Fred Smith Jan 142007 Harper Drive 8
Fred Smith Jan 14 2007 Harper Drive 12
Fred Smith Jan 152007 Harper Drive 8
Total hours at Harper Drive 46
Total hours
46
Or if more then one site :
Name Date Location Hrs
Fred Smith Jan 12 2007 Harper Drive 8
Fred Smith Jan 13 2007 Harper Drive 10
Fred Smith Jan 142007 Harper Drive 8
Total hours at Harper Drive 26
Fred Smith Jan 14 2007 Willow Drive 12
Fred Smith Jan 152007 Willow Drive 8
Total hours at Willow Drive 20
Total Hours 46
Now I am no pro to say the least but having great fun. The sorting of the
employee and the locations is easy. I also sort so this applies to a date
range of one week.. But how do you sort for the report first the hours
worked by the staff under or equal to 40 hrs Then sort those over 40hrs and
report on those.. my bet it is easy but I am lost. I have tried lots of
things but nothing works.
So here goes it... HELP
Many thanks
Bill.
have a table that I have that has the names and times that people have
worked.
Simple in format.
Date, Employee Name, Hrs worked , Location worked
So what I want to do is sort this info so that if first takes each employee
and adds there time up and on the report it states the employee name and
hours worked.
EG.
Name Events Total Hrs
Fred Smith 11 32.5
For those employees that are over 40 hrs I need to have a modified output.
I need to list the events that they worked and sort the events by Location
Worked so it should look like this :
Name Date Location Hrs
Fred Smith Jan 12 2007 Harper Drive 8
Fred Smith Jan 13 2007 Harper Drive 10
Fred Smith Jan 142007 Harper Drive 8
Fred Smith Jan 14 2007 Harper Drive 12
Fred Smith Jan 152007 Harper Drive 8
Total hours at Harper Drive 46
Total hours
46
Or if more then one site :
Name Date Location Hrs
Fred Smith Jan 12 2007 Harper Drive 8
Fred Smith Jan 13 2007 Harper Drive 10
Fred Smith Jan 142007 Harper Drive 8
Total hours at Harper Drive 26
Fred Smith Jan 14 2007 Willow Drive 12
Fred Smith Jan 152007 Willow Drive 8
Total hours at Willow Drive 20
Total Hours 46
Now I am no pro to say the least but having great fun. The sorting of the
employee and the locations is easy. I also sort so this applies to a date
range of one week.. But how do you sort for the report first the hours
worked by the staff under or equal to 40 hrs Then sort those over 40hrs and
report on those.. my bet it is easy but I am lost. I have tried lots of
things but nothing works.
So here goes it... HELP
Many thanks
Bill.