Increasing Number on a Report (Standing Invoices)

[Anthony Huggard]

I have a database for invoicing that is repeated each
month. ie: 'Standing Invoices'.

Each month a new invoice number is generated.

The easiest way i can think of is to print a new number
onto each report(invoice) using a counter.

What is the best method to do this?

 

[SA]

Anthony:

Why not create a table called "Invoices" with an auto number field and the
primary key used for the invoice (e.g. CustomerID) and a date, and then for
each invoice record to be generated, append the customerID and date to this
table, which would automatically create an invoice number, then link that
table to your invoice report query based on the customer ID and date of the
invoice. That way you'll never repeat invoice number and also avoid a lot
of code.