Avoid confusion: Repeat the group name on every page of a report
Avoid confusion: Repeat the group name on every page of a report
—by Christine Spencer
Application:
Microsoft Access 2000/2002/2003
Operating Systems:
Microsoft Windows
I have a report with records grouped by customer name. Each time the customer name changes, the report inserts the new name. Sometimes the records for one customer span more than one page, but this page doesn’t print the customer’s name again. That makes the report confusing be-cause it’s not clear which customer these records refer to. Is there a way to automatically repeat the customer name on the next page?
Actually, it’s very easy to repeat the name of the group when the group spans more than one page. This technique only works for reports that have at least one grouping level, such as records grouped by state or department.
To show you how accomplish this, let’s create a basic report listing
—by Christine Spencer
Application:
Microsoft Access 2000/2002/2003
Operating Systems:
Microsoft Windows
I have a report with records grouped by customer name. Each time the customer name changes, the report inserts the new name. Sometimes the records for one customer span more than one page, but this page doesn’t print the customer’s name again. That makes the report confusing be-cause it’s not clear which customer these records refer to. Is there a way to automatically repeat the customer name on the next page?
--Alex Poulsen
Actually, it’s very easy to repeat the name of the group when the group spans more than one page. This technique only works for reports that have at least one grouping level, such as records grouped by state or department.
To show you how accomplish this, let’s create a basic report listing
