Hi
I've tried that but it seems this is not possible
"Piet Linden" wrote:
On Jun 7, 3:07 pm, cjgav wrote:
Hi
Thanks for your help i;ve done that ut the problem is the number starts at 1
and I would like to tell it were to start
"bhicks11 via AccessMonster.com" wrote:
One solution might be to base InvoiceNo field on an autonum field. Run code
to add the autonum (or some variation of it) to the InvoiceNo field
before/when printing the invoice.
Bonnie
http://www.dataplus-svc.com
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
--
Message posted viahttp://www.accessmonster.com
remove the autonumber (make the field type long integer). Add a
record. Set the value of invoiceNumber to be one less than the one
you want. Change the field type back to autonumber.
Compact the database. And there you go.