report footer print only on page 1. Is it possible?

[Denise]

I am required to use a standard form which requires the total on the front
sheet. Is there a way to print the total only on page one?

Any help would be greatly appreciated.

 

[Al Campagna]

Denise,
Use the Format event of the report section where your total displays.
In this example, a control, named sumLength, which usually displays many
times over the length of the report...is only displayed on Page 1

Private Sub GroupFooter1_Format(Cancel As Integer, FormatCount As Integer)
sumLength.Visible = [Page] < 2
End Sub
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Bill]

You should be able to use something like
=SUM([MyField]) as the Control Source
of a text box in the Report Header, where
there's nothing else in the Header than what
you want to have appear.

Bill

 

[Gina Whipp]

Denise,

Thinking out loud...

Put a field txtPage with a control source of Page, make it invisible. Then
put: =IIf([txtPage]=1,[WhateverYourTotalFieldNameId],Null) in the control
source of another text field.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm