Report page footer section on 1st page ONLY + page # on all 1

[datahelper]

- How do I prepare a report with a page footer section on the first page only!!!

- All other pages should have only data from the detail section and then page number info at the bottom (i.e. page 1 of 10; page 2 of 10; page 3 of 10...)

This is for a critical job assignment and I need a quick response... PLEASE!

datahelper jcade4@yahoo.com

 

[downwitchyobadself]

This link explains using the OnFormat event of a PageHeader to show first and last records on the page, like in a phone book.

http://support.microsoft.com/support/kb/articles/Q208/4/12.ASP

You can do the same thing with a simple macro, setting your control source values for your footer between

"=[Page] & " of " & [Pages]

and

"="""

(You won't need the quotes in macros.)