Hi,

as invoice numbers have to follow without holes, never take an autonumber.
You'll always run into trouble later. Create a separate table which holds the
invoice numbers. Each time you need a new invoice number, you look up the
last used, add 1 to it and then update the number in the new table.
I always have three fields the last invoice nr. last year, last invoice
nr. this year, and last invoice nr. next year. This helps around the end of
December, start of January.
--
Kind regards
Noëlla


"cjgav" wrote:

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