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

Dan Waters dwaters at usinternet.com
Tue Nov 15 09:23:05 CST 2005


Bruce,

Something that still gets me occasionally is when I have a text box on a
report that has the same name as an underlying field.  Make sure this isn't
the case.

The text boxes on the report automatically get the same name as the field if
you've used a wizard to create the report.

Dan Waters

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bruen, Bruce
Sent: Monday, November 14, 2005 10:49 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Counting group headers in a report (FAQ)

...  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.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list