Invoice Numbers
in [Reports]
|
From: blanch2010 on 9 Feb 2010 11:41 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
From: Steve on 9 Feb 2010 12:09 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 santus(a)penn.com "blanch2010" <blanch2010(a)discussions.microsoft.com> wrote in message news:CF216A90-B905-474D-940E-87484FE8497F(a)microsoft.com... > 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 >
|
Pages: 1 Prev: Report with Subreports Next: Form filter with multi-column combo box in report |