How can I produce invoices with automatically incrementing number.

D

dalynn

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
 
F

Fons Ponsioen

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
 
D

Duane Hookom

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