[AccessD] Page numbers

Bobby,

One simple way, at least in theory it is simple, is to make each
contract into its own report instead all the contracts being one report.
However, it may be impractical in your situation to make this change.
Only you can tell whether this is a simple solution.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Bobby Heid [mailto:bheid at appdevgrp.com] 
Sent: Thursday 2003 Jul 24 08:18
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Page numbers

Hi all,

Have a report that ideally prints on one page per contract, but many
times could spill over to 2 or 3 pages for the contract.  The client
wants me to put page numbers like so:

page 1 of 1
page 1 of 2		| 2 page report
page 2 of 2		| here
page 1 of 1
page 1 of 1
page 1 of 2		| 2 page report
page 2 of 2		| here

etc.

I am not sure on how to go about doing this.  Any ideas?  I know that I
can reset the Page variable, but I do not think that I can reset the
Pages variable.

I am using Access 97 on Win 2k.

Thanks,
Bobby