Adding sums to a report?

  • Thread starter Thread starter ZBC
  • Start date Start date
Z

ZBC

I created a report of about 8 columns, based on a query, by using the
report wizard.
I then made some changes to the layout of the report my moving and
resizing most of the heading, etc.
I now have decided that I would like to have some of the columns totaled
at the bottom.
I realize that if I start all over again and used a wizard, etc. that
it will probably do the summing for me?
I would just like to understand more about customizing my reports, so I
am asking "How do I add sums without starting all over?"
.... or should I depend on a query to do it?
Bob
 
Bob,

In design view of the report, put an unbound textbox in the Report
Footer section for each field you want to total. Then, in the Control
Source property of the textbox, put the equivalent of...
=Sum([NameOfYourField])

- Steve Schapel, Microsoft Access MVP
 
ZBC said:
I created a report of about 8 columns, based on a query, by using the
report wizard.
I then made some changes to the layout of the report my moving and
resizing most of the heading, etc.
I now have decided that I would like to have some of the columns totaled
at the bottom.
I realize that if I start all over again and used a wizard, etc. that
it will probably do the summing for me?
I would just like to understand more about customizing my reports, so I
am asking "How do I add sums without starting all over?"
.... or should I depend on a query to do it?
Bob
Click to expand...
Bob,
Sum at the bottom of what?
The Report footer?
Just add an unbound control. Set it's cpntrol source to:
=Sum([SomeField])

The Page Footer?
See Microsoft KnowledgeBase Article:
132017 'How to sum a column of numbers in a report by page'
 
Back
Top