[AccessD] Page numbers

Gustav,

That is an interesting idea.  But this is a very slow report to print.  But
I like the idea!

Thanks,
Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock
Sent: Thursday, July 24, 2003 10:31 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Page numbers


Hi Bobby

Your problem is that you don't have the page count for each contract
and you can only obtain those reliably by printing or previewing the
report until last page. You could do that by printing the report to a
dummy file while collecting the page counts into a temporary table;
then join this table to the query of the report and do the real
printout - lots of potential fun here!

/gustav


> 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