Prev: MS e-learning 5456ae lab
Next: Running Total in report using net of two columns in third column
From: S on 7 Mar 2010 21:11
Hello,

I have a report that is grouped on [SessionNum] with many records under each
[SessionNum]. The records are sorted ascending by [EntryNum].
What I would like to do is insert a page break on the last 5 records of each
[Session].

Is there cody that could be written for this?
From: Marshall Barton on 7 Mar 2010 21:41
S wrote:
>I have a report that is grouped on [SessionNum] with many records under each
>[SessionNum]. The records are sorted ascending by [EntryNum].
>What I would like to do is insert a page break on the last 5 records of each
>[Session].


Strange thing to do, but not all that difficult.

Add a text box (named txtLineNum) to the detail section.
Set its expression to =1 and RunningSum to Over Group.

Add another text box (named txtDetailCnt) to the group
header section. Set its expression to =Count(*)

Add a Page Break control (named pgBreak) to the top of the
detail section.

Add a line of code to the detail section's Format event
procedure:
Me.pgBreak.Visible = (Me.txtLineNum = (Me.DetailCnt - 5))

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: MS e-learning 5456ae lab
Next: Running Total in report using net of two columns in third column