 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / December 2005counting only footer enties
I understand how to count items and rows, but i need some advise on how to count the number of footers in a report. I have Detail that creates a various amount of entries. i have a Footer that sum's the individual detail. I have a Report Footer that sums all the detail. what i want a count entry for is the number of Footers. Any ideas Add a text box in your group footer: Name: txtCountGroup Control Source: =1 Running Sum: Over All Visible: No Add a text box to your Report Footer: Control Source: =txtCountGroup  SignatureDuane Hookom MS Access MVP -- >I understand how to count items and rows, but i need some advise on how to > count the number of footers in a report. [quoted text clipped - 3 lines] > what i want a count entry for is the number of Footers. > Any ideas Add a text box to your Group Footer section, and give it these properties: Control Source =1 Running Sum Over All Format General Number Name txtGroupCount Visible False Now add a text box to the Report Footer where you want to show the number of group footers, and set its Control Source to: =[txtGroupCount] SignatureAllen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. >I understand how to count items and rows, but i need some advise on how to > count the number of footers in a report. [quoted text clipped - 3 lines] > what i want a count entry for is the number of Footers. > Any ideas ahhh, perfect, thank you very much. > Add a text box to your Group Footer section, and give it these properties: > Control Source =1 [quoted text clipped - 14 lines] > > what i want a count entry for is the number of Footers. > > Any ideas UNTESTED- Going from memory. Add a control to your summary footer. Name to the control CountFooterLines Set its control source to =1 Set its sum to overall Set its visible property to False In the Report footer Add a control Set its control source to = CountFooterLines >I understand how to count items and rows, but i need some advise on how to > count the number of footers in a report. [quoted text clipped - 3 lines] > what i want a count entry for is the number of Footers. > Any ideas |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.