Access row count

[Joseph]

Hi, I am trying to create a report in Access 2003 where I can obtain the
number of rows and assigning the row number in the results like the following
example:

ROW NUM FName LName
------------------------------------------
1 James Bond
2 Albert Einstein
3 Bill Gates
4 George Washington
5 Abraham Lincoln
6 Marie Curie


How can I accomplish this?
Thanks

 

[fredg]

Hi, I am trying to create a report in Access 2003 where I can obtain the
number of rows and assigning the row number in the results like the following
example:

ROW NUM FName LName
------------------------------------------
1 James Bond
2 Albert Einstein
3 Bill Gates
4 George Washington
5 Abraham Lincoln
6 Marie Curie

How can I accomplish this?
Thanks

Add an unbound text control to the detail section of your report.
Set it's control source to:
=1
Set it's Running Sum property to Over All.

That's it.

 

[Joseph]

Thanks Fred,

Works like a charm!

Add an unbound text control to the detail section of your report.
Set it's control source to:
=1
Set it's Running Sum property to Over All.

That's it.