Summing or diferent sites within a day

  • Thread starter Thread starter Ashley
  • Start date Start date
A

Ashley

Hello! I have an employee attendance database for 2 sites, FL and AZ. My
report is sorted first by date, then by site then by reason (there are 8,
e.g. "Vacation")

I have a sum in each Reason footer that gives me the total number of hours
everyone at that site was out for a particular reason.

I also have a sum in each date footer that gives me the total number of
hours everyone at both sites was out for all reasons.

What I need is this sum in the date footer to be broken up by Reason,
regardless of site.

Thank you for your help!
 
I would expect you could accomplish this with a subreport based on a totals
query.
 
Back
Top