It is better to create an autonumber field in the table the report is based
on. Simply add a filed to your table and make the datatype autonumber. Then
it is usually better to make it a primary key.
the report is generated by a complex query so i will either have to create a
new table with autonumbers to print the report or i would prefer to create an
autonumber field in the report. could i achieve something like that?
If you need only a text box appearing nearby each record in your report,
showing the serial number of this record:
1. Add a text box in the detail section of your report
2. Set its control source to =1
3. In the Properties of this text box search for the Running Sum and change
it to Over All / Over Group.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
