Report Total Problem

[Mitch Powell]

I have a report using a data source with 15 columns: Job, Account, Year and
Jan-Dec. The report is grouped by Job. For each Job there are 10 accounts
and 4 years for a total of 10 X 4 = 40 records for each Job. The 40 records
for each job print on a single page and there is a page break for each new
job. Here's my problem:

I want a "Totals" page that shows the total for each of the 40 records
contained in all the preceeding Job pages. This page would look exactly like
the individual Job pages (i.e. 40 records) but would represent report totals.
I put the Account, Year and Month fields (using =Sum([month]) syntax) in the
report footer but all I get in the report footer page is a single record
displaying the first Account and Year. What am I missing?

 

[akphidelt]

Im not sure what you are trying to do can be done like the way you want to do
it. What I do when I want to show multiple types of info on a single report
is to create a subreport in the report header or report footer section. So in
your case under the report footer section you would insert a subreport and
create the report that groups the information by jobs and shows the totals.

If you want an easy way to create a subreport... right click on the
subreport, go to properties. Make sure you go to the properties where it says
report. Then under the Record Source... click the little 3 periods "..." and
create a query that does all the grouping and totalling for you.