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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding consecutive numbers to a field in a report page header 3
Mail Merge with a many-to-one report/query 1
Using a template on a report 1
VBAscript for data matching excels 0
Fax Individual Report via command line 1
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Saving Invoice as PDF 3
Assigning print date / batch number to reports & invoices 6

Back
Top