Running Sum in Report Footer

  • Thread starter Thread starter Amy
  • Start date Start date
A

Amy

I am trying to run a lump sum of data from a different
number of categories in the report footer, but it is just
pulling numbers from different regions, not pulling a sum
or even pulling them from one area for that matter.

This is how I have it set up

Detail

Region A
Dr.'s # EMT's #
Nurses # Police #

Region B
Dr.'s # EMT's #
Nurses # Police #

Report Footer
Dr.'s A#+B# EMT's A#+B#
Nurses A#+B# Police A#+B#

How do I get this footer to work?
 
I'm not sure how you expect us to know when you don't provide any
information regarding your table structure. Are you showing fields or
summaries of a single field or what?

I expect you need a subreport based on a totals query.
 
You must log in or register to reply here.

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 in a Report Footer 7
IIF function in Report Footer 5
A03 - count in report footer gives me #Error? 0
Excel Unique last page footer 1
Partial Report footer sum 1
Sum unique entries in report footer 2
Totaling Sums for Price and COMM 3
counting unique values in report footers 7

Back
Top