incremental invoice number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an invoicing report that sorts by lease number (one lease per
invoice). I set up the report so that I enter the beginning invoice number
(000) and the report increments each invoice by adding the page number to the
beginning invoice number. This is fine for single page invoices, but if an
invoice goes to a second page, the second page gets a new invoice number.

Any suggestions?
 
Add a new controlto the section where you keep the invoice number
Name it txtOneUp
Set its Control source to =1
Running Sum to Over All

That could be all you need. If you need to adjust this to a different start
point (Start with 222), then simply set txtOneUp to be not visible and then use
it in your current code in place of the Page number.
 
Chet,
I see that John Spencer has responded to your question... and I'm sure
that will solve your problem.
But... I'd like to ask you why you are assigning Invoice Numbers on your
report. I would think that the InvoiceNo would be assigned when the data
was entered, and captured in your table.
Or... perhaps when you say "InvoiceNo" you just mean a "count" of
invoices printed?
Al Camp
 
Al,

This is an invoicing report for leases. The report is run on a monthly basis
and the invoices are generated from the data in the table, but each month the
leases are numbered differently. So for january, invoice #'s 1257 - 1498 were
used and in February 1499 - 1674 were used. I'll try John's solution and see
how it works.

Thanks all.

Chet
 
Back
Top