URGENT!! Running an update query after printing a report

[William Watterson]

How would i go about running an update query (to
increment the invoice number by one) each time an invoice
is printed. I need Access to do this when printing
batches of invoices. For example say i was to print ten
invoices to ten different customers by selecting a macro
which was to print all outstanding invoices, how would i
get the invoice number to change every time a new
customers details appeared???

 

[Rick B]

Not sure I understand. The invoice number should be a field in your table.
The report should not calculate it. What if you have to reprint an invoice?

You set the invoice number when you store the invoice record in your table.

Rick B

 

[Guest]

William,

I used the following for invoice numbers. I have the report query what the
last invoice number was, then the invoice number is assigned by adding the
page number to the last invoice number.

in the page header:
=[last invoice number]+[Page]

Unfortunately if you have an invoice that is more than one page this doesn't
work. I have asked for a workaround in this forum on 3/1/05. Check it out for
other solutions.

Chet