Overall Average

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report which groups on Dept and shows number of complaints resolved,
and average age of complaints by department. There is a new page for each
department. I want to show an overall average on each page, and have made a
subreport with hospital average, but when I add it to the main report, it
comes up empty. Any help would be appreciated.
 
You might want to check to see if Access helped you and placed values in the
Link Master/Child properties. If so, try remove them.
 
Did that, didn't help. But I found another post elsewhere suggesting a
Dlookup formula, which worked great. Thanks!
 

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

Report with pivot tables and pivot charts in sub reports 6
Totaling Multiple Subreports 5
Creating a report with criteria 1
count in parent report footer 2
Sorting by Average 7
Running Avg. 1
How can I sort an access report by an avg value in a footer? 2
Charts for each record in report 1

Back
Top