Totals on Report

G

Guest

I have a report grouped like this:
Level 1: Agent
Level 2: Location
Then I have data by date for 3 locations:
Mon
Tue
Wed
Thur
Fri
Total for week
Then in my agent footer I need totals for all locations by date:
Mon
Tue
Wed
Thur
Fri
Totals

Everything works perfect except I can't get my totals in the footer to fill.
It seems like this should be a normal function for a report but I cant get
it to work. Someone please help me. I am pulling out hair.
 
D

Duane Hookom

Create a query similar to your report's record source however make it a
totals query that totals by Agent and day of week. Use this as the
recordsource of a subreport. Add the subreport to the Agent footer and set
the Link Master/Child properties to the Agent field.
 

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

Totals by date on report footer 1
Group Totals and Grand Totals on each page 3
Line charting the same series using data from multiple sheets? 1
Week number 1
Calculating Percent of a Group in Report Footer 2
Report Totals 3
totals not visible in report 2
Printing group totals in the page or report header 4

Top