Invoice Numbers

[Guest]

We produce reports that are invoices.. The reports are really a group of
compined reports if this matters... When we print the reports I would like to
have printed consecutive invoice numbers. If possible I would like to have
the number apprear as AS-00001, AS-00002 ect.. I am not really interested in
storing the invoice numbers I just need them on the printed invoice as it is
made of of groups of various data that is stored...

Thank In Advance for you help.

Bob

 

[Allen Browne]

If you just want a consequetive numbering on the report, all with an AS-
prefix, see:
Numbering Entries in a Report or Form
at:
http://allenbrowne.com/casu-10.html

Having made the text box with the running sum, set its Visible proeprty to
No, and its Name to (say) txtCount. Then add another text box with Control
Source of:
="AS-" & [txtCount]

I don't actually believe that this will be adequate. For example, a client
wants to argue about an invoice and you can't even identify what invoice
number he is tallking about.

There's a brief disucssion about the normal way to batch invoice at the end
of this article:
http://allenbrowne.com/ser-64.html#Example