Add Serial Number column to a report

[Amer]

I have a report showing names and file numbers of employees. I need to add an
"SN" column showing the serial number of each row automatically.

 

[tina]

when you say "row", i assume you mean record. you're not giving much
information. where is the serial number data stored, what have you tried to
do to get the data to show on the report, and what problem(s) are you
encountering?

hth

 

[Ken Sheridan]

Do you just want to number the rows, starting at 1? If so add a text box
control to the detail section, set its ControlSource property to =1 and its
RunningSum property to 'Over All'. If the report is grouped, and you want
each group's rows to restart at 1 set the RunningSum property to 'Over Group'.

Ken Sheridan
Stafford, England

 

[Amer]

Thnak you very much. That solved the question.

Do you just want to number the rows, starting at 1? If so add a text box
control to the detail section, set its ControlSource property to =1 and its
RunningSum property to 'Over All'. If the report is grouped, and you want
each group's rows to restart at 1 set the RunningSum property to 'Over Group'.

Ken Sheridan
Stafford, England

 

[Amer]

Yes, I mean record.

Actually, I don't want to store the number data. It's only to count the
records in the report. But rather than getting a total in the footer of each
group, I want a count number or, say, a serial number to appeat next to each
record.