invoice number

Noella explained how to do it. You make another table with 1 field. In the
field you put the first invoice number. When you print the invoice, set the
invoice number to the value of that table.field. Then you run an update
query to add one to the value in the field so that the next invoice will have
the next number.

Bonnie
http://www.dataplus-svc.com

cjgav wrote:
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 .

And what happens when you print the same invoice again later? Do you want a
different invoice number to be created?
[quoted text clipped - 8 lines]
when
the invoice is printed can anyone explain how to do this please

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200906/1