How can I produce invoices with automatically incrementing number.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to produce invoices with automatic incrementing numbers. I also want
to produce them in different languages and use different number sequences
for each.

I am using Access 2003
 
Hi Dalynn.
You could use something like Max(CurrentNumber)+1.
You may want to consider if there is a possibility of some invoice being
deleted, this could cause an issue.
Hope this helps.
Fons
 
I don't think this is a report question. You should update a field in a
table to the appropriate invoice number and then report the values
afterward.

Reports are not the place or time to modify data.
 

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

Incrementing invoice number 1
Invoice Numbers 1
Mail Merge with a many-to-one report/query 1
incremental invoice number 3
Invoice number 1
Adding consecutive numbers to a field in a report page header 3
Fax Individual Report via command line 1
URGENT!! Running an update query after printing a report 2

Back
Top