Generating an auto-number on a report?

[skuldren]

First off, can it be done? I'm using Microsoft Access 2007, I'm wanting to generate an auto-number on the report. Basically I have an OrderTable, a PartTable, and a PackingListTable. I have a report that shows all orders ready to be shipped. But I need the shipping report to have a packing list number. I want this number to be auto-generated, and I was hoping I could do this when the report is opened. Right now the report is generated through a query of orders that are ready to be shipped. Yet I can't figure out how to put an auto-generated packing number on the report.

 

[dhookom]

It isn't real clear what you are asking. Do you want to number the detail records? If so, add a text box to the detail section:
Control Source: =1
Running Sum: Over all (or Over Group)

Duane MS Access MVP

 

[projecttoday]

If you can't use the autonumber from the packing list table, make another table with an autonumber field in it. Add a record to this table when the report is opened.