Invoice Numbers

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
 
S

Steve

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
[email protected]
 
Top