column totals

  • Thread starter Thread starter Krista
  • Start date Start date
K

Krista

How do I calculate a total on the page footer for columns
that I made using the line feature.


mmmm 20.00 10.00 5.00 4.50
mmmm 10.00 7.00 12.00 8.00

Total 30.00 17.00 17.00 12.50

the total is what I am trying to calculate, however each
line is a different record, this is in a report, and the
report is some 150 records long. Each page has 4 records
on it. I want to calculate 5 columns on each page in the
page footer and have tried everything I can think of. I
also need all the totals on the bottom of all the pages
to be added up and appear in five seperate columns as a
report footer.
Please help if you can.
Thanks
 
-----Original Message-----
How do I calculate a total on the page footer for columns
that I made using the line feature.


mmmm 20.00 10.00 5.00 4.50
mmmm 10.00 7.00 12.00 8.00

Total 30.00 17.00 17.00 12.50

the total is what I am trying to calculate, however each
line is a different record, this is in a report, and the
report is some 150 records long. Each page has 4 records
on it. I want to calculate 5 columns on each page in the
page footer and have tried everything I can think of. I
also need all the totals on the bottom of all the pages
to be added up and appear in five seperate columns as a
report footer.
Please help if you can.
Thanks
.
Click to expand...
First you should add a grouping level to the report based
on what ever it is you are getting your 4 records from.
Select the footer option for that group then put a text
box in the footer and make its control source "=Sum
([FieldName])" for each of the 5 fields you want to sum.
Do the same for the report footer to get totals for the
whole report.
 
Back
Top