Invoice Numbers

  • Thread starter Thread starter blanch2010
  • Start date Start date
B

blanch2010

Is there a way to automatically generate an invoice number in Access 2007?

Invoice report is built but needs a invoice number to be self generated.

Thank you in advance.
Don
 
You probably have an invoice table that looks like:
TblInvoice
InvoiceID
InvoiceDate
CustomerID
InvoiceNumber
etc

In your invoice form you need the expression:
InvoiceNumber = DMax("[InvoiceNumber]","TblInvoiceNumber") + 1
where InvoiceNumber is the name of the field for InvoiceNumber.

Steve
(e-mail address removed)
 
Back
Top