Invoice Numbers

[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

 

[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
(e-mail address removed)