Autonumbering Reports

[Eminem]

Hello, I am trying to put an autonumber on my invoices for an invoice number. I can use Count in the report, but I need it to keep a running autonumber forever, not start new numbers everytime the invoices are run. Can anyone help?

 

[Rich]

Why can't you put an autonumber in the table that the invoice details are coming from?

 

[Eminem]

The table that they are coming from can have more than one record that will appear on the invoice. Two entries that have the same company, need to both appear on the invoice together. I can put an autonumber on that table, but when they are grouped on the report it will only display one of the numbers. The numbers need to be sequential.

ie.

INVOICE# 100

Work Order 100 Total
Work Order 101 Total

The next invoice would display:

INVOICE# 102

Work Order 102 Total

I need an autonumber that only increases when the report is run, and increases per grouping.

 

[mark curtis]

Hide a new text box on the report menu called txtRef
On click event of the button that runs the report

txtRef.value=txtRef.value+1

Set the default value to 0001 and ref the txtRef on the report

 

[lipin]

I am trying to put this type of an invoice number on a report. I need consecutive numbers each time this report is printed.

I put a textbox called txtInv next to the command button used to print the report and hid it.

Tried putting the following in the On Click Event of the print button:
txtInv.value = txtInv.value +1

On the report I had a txtbox in which the control source was:
=[forms]![myformname]![txtInv]

It works fine and prints out a consecutive number until I close the application and open it again. I set the default to 30000 on the text box on the form. So when I print all the invoices for the day all is fine. But the next day after starting the application agian, it sets invoice number to default and I get repeat numbers. How can I get it to stop defaulting? I need a new invoice number everytime it prints.