[AccessD] Page numbers

Thanks for the input.  Unfortunately, this report is ran from a form where
the user can print for one contract, all contracts in a project, pick number
of months to print for each contract, etc.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Wortz, Charles
Sent: Thursday, July 24, 2003 9:19 AM
To: Access Developers discussion and problem solving
Subject: RE: [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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 2639 bytes
Desc: not available
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030724/da2573ef/attachment-0001.bin>