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