Numbering Records

[George]

Good Night All.



I would like to know how to code a report to add row numbering automatically?




Thank in advance.

[ItsMe]

A report's VBA module id generally used to format the report. A user does not interact with a report in a way to fire code. Of course, I am sure there is someway you could get a function to fire from a report when it opens or closes. Just not sure why you would want to when there are forms.

[mrojas]

You could generate a table that holds all the records for the report, including an empty field, say LineNo (numeric).
Then using a recordset, in a loop, traverse it incrementing the LineNo field.
Use the new table as the date source to your report.

[George]

Thank I would try it. But don't you think by now such a feature should have been included in Access?

[ssanfu]

In the detail section of the report, add a text box.
Set the control source to "=1"
Open the properties dialog box. Click on the data tab.
Change the "Running Sum" property to "Over All".
View the report.

Attachment 14086

[mrojas]

What Steve suggested is much better and easier to do. Go for it.

[George]

Thanks to you all.

Steve that's a wonder easy suggestion. I work fabulously. A very special thanks to you.

George