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

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!

On Thu, 20 May 2004 05:45:38 -0700, OsmondB wrote:

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!

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"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.