If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Displaying a "Sum()" Text Control Only Once On A Report
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. |
Thread Tools | |
Display Modes | |
|
|