subreport in report footer (Access 97) 1

[pamgdevlin]

Help....

Have a report with page break after my group footer (have name in page header so logo repeats on every page, but each page has different agency name on it). Report ends fine without a blank page, but if I place a subreport in the report footer, the name of the agency on the previous page shows up on the page with the subreport. How do I eliminate the agency name on the last page with the subreport???

Thanks for any help

 

[AlexMidd]

Agency name should probably be in a group header for the agency field, rather than the page header.

Have fun! )

Alex Middleton

 

[pamgdevlin]

Thank you Alex....sometimes I have to be hit on the head to see the obvious....I usually avoid using the group header because I like to have the name on each page in case the data produces multiple pages for each agency, however, in this case putting the name in the group header will work as each agency has only one page in this particular report.