Access row count

  • Thread starter Thread starter Joseph
  • Start date Start date
J

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
 
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
Click to expand...

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.
 
Thanks Fred,

Works like a charm!

fredg said:
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.
Click to expand...
 
Back
Top