Invoice number

[Jeanne]

Hello,
I need to have a field on a report that represents a invoice number. I
would like the user to have a pop up on open to enter a starting number and
have it increment one one each page after. I do not need the invoice number
to be stored in the database.

 

[Marshall Barton]

I need to have a field on a report that represents a invoice number. I
would like the user to have a pop up on open to enter a starting number and
have it increment one one each page after. I do not need the invoice number
to be stored in the database.

Add an invisible text box named txtStart to the report's
Header section and set its control source expression to
=[Enter Starting Serial Number]

Then add an invisible text box named txtCount to the invoice
header section. Set its control source expression to =1 and
its RunningSum property to Over All.

Finally, add a visible text box to the invoice header
section and set its control source expression to
=txtStart + txtCount - 1