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.
 
Back
Top