hi
I want to keep the same number .
I enter the info in to the database to create a estimate for customer when
the estimate is excepted and the job is completed I want a table with invoice
date in which I have used an append query to update but I cannot create an
invoice number without using autonum which will not produce the numbers I
want .

"Steve" wrote:

And what happens when you print the same invoice again later? Do you want a
different invoice number to be created?

Why don't you create the invoice number when you enter the invoice data in
your invoice form?

Steve



"cjgav" wrote in message
...
I would like to add an invoice number to report which is generated only
when
the invoice is printed can anyone explain how to do this please