X of Y

[Jeff Harrison]

--- Gary Olman <garyolman1 at hvc.rr.com> wrote:

>  Thank you all, but here is the precise problem. I
> am printing invoices in a
> batch process. Some of the invoices are 1 page long
> so page 1 of 1 is called
> for, some are more than 1 some are 2 pages long some
> are 3 and so on. The
> page number should total on the last page of each
> invoice. The invoices are
> sorted by invoice number, with a break on invoice
> number change.
> Gary
> 

Are you using the print command or remove unwanted
blank lines?  If not you should still be able to
calculate the total number of pages by doing a lookup
next to first calculate the number of records for a
given invoice - then you can derive the total pages
for each invoice based on the
(TotalRecordsThisInv/NumberOfRecordsPerPage) rounded
up.

You would need to do this calculation each time the
Invoice number changed.

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The easiest and
fastest ways to generate code for filePro exports and imports.


	
		
__________________________________ 
Yahoo! Mail - PC Magazine Editors' Choice 2005 
http://mail.yahoo.com