I am using Access 365.
I have a report listing transactions, grouped on different offices. Each group starts on a new page via the "force new page before section" property setting for the group header. The group header contains the labels for the headings for the data fields in the detail.
The totals for the data fields and some calculated figures are in the group footer. I want to print the last page for each group, which is the group footer, without the group header on it.
I was thinking about having a macro set the value of the [Visible] field to "NO" for all of the headings labels in the group header ... but then this needs to be linked somehow to only run when the group footer is printed or displayed. Can someone tell me what I am missing ... there must be an easier way of doing this?:banghead:
I have a report listing transactions, grouped on different offices. Each group starts on a new page via the "force new page before section" property setting for the group header. The group header contains the labels for the headings for the data fields in the detail.
The totals for the data fields and some calculated figures are in the group footer. I want to print the last page for each group, which is the group footer, without the group header on it.
I was thinking about having a macro set the value of the [Visible] field to "NO" for all of the headings labels in the group header ... but then this needs to be linked somehow to only run when the group footer is printed or displayed. Can someone tell me what I am missing ... there must be an easier way of doing this?:banghead: