labour report

[Guest]

So I am attempting to find a solution to a sorting and reporting issue in
Acces 2003.
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.

 

[Guest]

I would probably start by creating a query similar to your report's record
source except that it sums the hours by employee. This totals query can be
added to your report's record source and join the employee fields. You should
now be able to include the total hours in the report's record source.

You can add the total hours to a hidden text box in the detail section. If
this field is less then or equal to 40 then cancel the printing of the
section. You could also have a grouping by location after the employee. Use
similar code to cancel the printing of location footers:

Cancel = Me.txtTotalHrs <= 40