Summary of Hours in a Report

[Jen]

Dear All, I would welcome any help on a report I am trying to produce:

I need a report that shows cleaning hours for various buildings. I have set
up a table where I input the building, area(s), staff name(s), Mon Start
Time, Mon End Time, Tue Start Time, Tue End Time, and so on.

My report has group headers of Building, then Area, then Name. I can put in
the number of hours for each name per day, then the total number of hours per
week for each name.

However, I need the report to also show the TOTAL number of hours spent
cleaning for each Building. I have tried various summary options and
calculations, but it only shows the total for one person, and I need to total
ALL the hours for EVERY person cleaning in each Building.

I hope this makes sense, and thank you in advance for any help!

 

[NetworkTrade]

best if this was posted in the 'Report' area.

it sounds like you need to create a new group for Building; in design view
mode use the grouping function to create it.

 

[Cheese_whiz]

Hi Jen,

Are you using a group header/footer for the buildings? It sounds like it's
your top level group, but even that isn't required. As long as you have your
group (buildings) in a group header, you need a group footer for it and then
you can add a text box to the group footer and set it's control source to
this:

=IIf([HasData],Count([YourReportsRecordSourcePK]),0)

Replace the [YourReportsRecordSourcePK] with the actual name of the primary
key field in your query or table (keep the brackets surrounding it, though) .
It should work.

HTH,

CW