[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