report over two pages_requires different backgrounds

[blewis81]

I have two separate reports that use pictures (external PDF forms) as backgrounds. First pages of both reports can only have about 4 or 5 rows before needing to be on another page so as not to misalign fields.


One report's second page would be an excel. But the second would have the external pdf's second page. How do I do this? Both reports would be emailed. Think I should use the totalcount function but that's all I got. THANK YOU

[ranman256]

in the ON PAGE event of the report, swap the image:

Private Sub Report_Page()
If [Page] = 2 Then
   img.Picture = ("C:\Pictures\Pge2Img.jpg")
End If
End Sub

[blewis81]

Done as suggested.....but how do I correctly use the totalcount function to implement that?

[ranman256]

in the query, make a field =1.
add to the report, set the property to running sum. (or if you have a count field, then =sum([countFld])

[blewis81]

Going to have to "dumb it down" further I'm afraid. I added a "=1" column to query so now there is a "Expr1: 1" field in Design view / Expr1 field in Datasheet view.
I assume "Add to the report" means I add the =1 field from "Add existing fields." I did change the Control Source to =1 (because Expr 1 just doesn't seem right) I put in footer and made it not visible...is that the correct location? Property set to running sum "Over Group". IF this is all correctly interpreted.....how do I make it >5 on first page and <6 on second page?
Thank you!