Thread: invoice number
View Single Post
  #3  
Old June 7th, 2009, 09:07 PM posted to microsoft.public.access.tablesdbdesign
cjgav
external usenet poster
 
Posts: 54
Default invoice number

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 via http://www.accessmonster.com