Report - page footer

[Valerie]

I created a report which is an invoice.
My customer wants the invoice total to appear on the last
page of the invoice and on the bottom. In design view I
have the field visible = No. Then in the On Format and the
On Print of the Page footer I have an IF [page] = [pages]
and change visible = true.

When I preview it, the report is perfect only a total on
the last page, but when I print it the total shows on all
pages.

HELP!

 

[PC Datasheet]

Valerie,

Whatever is in the page footer comes out on every page when you print. Put your
total in the form footer; it only comes out on the last page.


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel