Serial Number of records in report

[Guest]

How create serial number of record in report created from query

 

[Guest]

Create a text box in the Report details section, in the ControlSource of the
text box write
=1

And set the RunningSum property of that the text box to "Over All"

That way it will add 1 for each record

 

[Douglas J. Steele]

By "serial number", do you mean a sequential number indicating the row
count?

Add a text box to your report, and set its ControlSource property to =1
(including the equal sign). Set its RunningSum property to Over All (or Over
Group if you want the count restarted each time the group changes)