MS Access Report Question-Repeat Header

[RedBarchetta]

Report for the mail room and only 2 sheets can be inserted into an envelope. I need to repeat the first page with the addressee associated with the groups each time the number of groups span more than one second page. The addressee is in the first page and their associated data is in a sub report with a forced page break so they are on the next page of the report. This works fine but when the number of groups span more then one page I need to repeat the first page of the report with the addressee and then their remaining groups on the next page. I need this to happen each time the number of groups span more than one page.

Thanks!

 

[Remou]

Hi
Here is a possible solution to your print problem.
1. Generated a sequential number for each occurance within the group (ID1, 1,2,3; ID2, 1, 2 etc)
2. Set the Group Header Repeat Section to Yes
3. Add this to the appropriate Group Header Format Event:

If fldOccurance Mod 2 = 0 Then
	Me.PrintSection = False
End If

I'm sure there must be an easier way, but this seems to work.