Displaying a "Sum()" Text Control Only Once On A Report

  • Thread starter Thread starter OsmondB
  • Start date Start date
O

OsmondB

Hi all,

I'm trying to count the Yes/No field on a report. I used
the expression =ABS(Sum([Starter])) in the Detail section
of the report and it prints the detail after every record
instead of just once at the end of the report, but it does
count the total number of Starters (Total "Yes") correctly.
Then I tried to put it in the Page Footer section to
ensure it appeared at the end of the report/page, but if I
do that the results for counting the Yes/No field displays
#Error instead of counting the total "Yes" like it did in
the Detail section. If anyone has any comments/advice it
would be greatly appreciated. Thanks!
 
Hi all,

I'm trying to count the Yes/No field on a report. I used
the expression =ABS(Sum([Starter])) in the Detail section
of the report and it prints the detail after every record
instead of just once at the end of the report, but it does
count the total number of Starters (Total "Yes") correctly.
Then I tried to put it in the Page Footer section to
ensure it appeared at the end of the report/page, but if I
do that the results for counting the Yes/No field displays
#Error instead of counting the total "Yes" like it did in
the Detail section. If anyone has any comments/advice it
would be greatly appreciated. Thanks!
Click to expand...

You cannot do calculations like this in the page footer.

Make the control in the Detail section not visible if you don't wish
to show it. Let's name that control "CountUp".
Then refer to it in the unbound control in the page footer:
=[CountUp]

For more help see Microsoft KnowledgeBase article:
132017 'How to sum a column of numbers in a report by page"
 
Back
Top