Summing or diferent sites within a day

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!
 
D

Duane Hookom

I would expect you could accomplish this with a subreport based on a totals
query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing of Different sites within a day 1
Subreport Summary 1
Summing Different Cycles 2
Trying to Count 3
SUM of COUNT? 8
Use a field from another report as the control source in a 2nd rep 0
Summing a data field for the whole report 3
getting an average on the "Count" in a report summary 2

Top