Sum inside Page Header

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

Guest

I want to put a text box in the page header of a report that sums one of the
columns from the details section below. Not just a sum of the page, but a
sum of this column through the entire report. I have tried, but can't seem
to make it work.

If anyone knows how to successfully do this, any help would be greatly
appreciated.

Thanks,
Chris
 
You need to put your calculation in the Report Header (or Footer) not the
Page Header, this will sum values for the entire report

Sheila
 
Yes, I do know that you can put the sum in the report header, but I really
need it in the page header at the top of every page.

-Chris
 
Ah sorry, in that case you can use DSUM something like
=DSum=DSum("[FieldName]","RecordSOurce","Criteria if required")

Sheila
 
Chris said:
I want to put a text box in the page header of a report that sums one of the
columns from the details section below. Not just a sum of the page, but a
sum of this column through the entire report. I have tried, but can't seem
to make it work.

If anyone knows how to successfully do this, any help would be greatly
appreciated.
Click to expand...



Put text box named txtSum in the report header section and
set its control source expression to something like
=Sum(thefield)

Then your page header text box can use the expression
=txtSum to display the total on each page.
 
Back
Top