Sum of sum in a report

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

Guest

I have a database with fields for type of items (1 col), and groups of ages,
0-30, 31-60, etc (6 col), plus a total field (1 col). There are four types
of items and $ values in each groups of ages and the total field. I have
made a query pivot table view that shows totals for each type and totals for
each group by age at the bottom, and totals on the right. It is what I am
looking for except I want to put it in a report to look more professional. I
tried to make a report of the query table but can not get totals in the
report footer. It puts the first item total in the report footer only. If I
put a totals box in the detail area it generates a running total after each
detail sum. The last running total is what I want but not the running totals
at the end of each detail.

Should I go back to the original table and generate the report from the
detail data and not the summary queries?
 
To best utilize the power of MSAccess, you should restructure your table to
have 2 columns - ItemType and AgeGroup.
 
I solved the problem without re-dueing the database (not an option). I kept
the running totals in the detail section of the report but made them not
visible. I then put a line of text boxes in the report footer and made them
equal the running totals. The last running total ended up as the result of
this total. Just what I was looking for. Sorry if it not "Access correct"
but it worked.

Ken
 
Not being a Access expert. I just needed to learn the proper syntac.

=sum([Thing to sum]) put that in the report footer and your good to go.

How simple yet not obvious to the novice.

Ken
 
Back
Top