[AccessD] Counting group headers in a report (FAQ)

Bruen, Bruce Bruce.Bruen at railcorp.nsw.gov.au
Mon Nov 14 22:49:25 CST 2005


...  I've done this a zillion times....
 
A colleague asked me how to get a count of the group headers in report.
He has a query based report that has a single group header/footer and
wants just the summary report, so he makes the group header and detail
sections invisible (a neat trick to get a quick summary report that I'd
never thought of by the way.).  Now he just wants to count the group
footers and put that count into the report footer.
 
So I just popped an unbound textbox into the footer, named it grpcnt and
set its value to =1 and in the report footer I put another unbound
textbox with value =Sum([grpcnt]).  I am sure I've done this before!!!  
 
A97 thinks that [grpcnt] is some type of parameter for the report and
pops up a parameter entry form when I run the report.
 
Erstwhile MSAccess guru exits stage left with egg on face and begs
AccessD'ers for the solution....
 
 
bruce


This e-mail and any attachments may contain confidential information that is intended solely for the use of the intended recipient and may be subject to copyright. If you receive this e-mail in error, please notify the sender immediately and delete the e-mail and its attachments from your system. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient. Any opinion expressed in this e-mail and any attachments is not an opinion of RailCorp unless stated or apparent from its content. RailCorp is not responsible for any unauthorised alterations to this e-mail or any attachments. RailCorp will not incur any liability resulting directly or indirectly as a result of the recipient accessing any of the attached files that may contain a virus.



More information about the AccessD mailing list