Sum of sum in a report

[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?

 

[MacDermott]

To best utilize the power of MSAccess, you should restructure your table to
have 2 columns - ItemType and AgeGroup.

 

[Guest]

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

 

[Guest]

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