 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / February 2008Access row count
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 [quoted text clipped - 11 lines] > 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.  SignatureFred Please respond only to this newsgroup. I do not reply to personal e-mail Thanks Fred, Works like a charm! > > 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 [quoted text clipped - 18 lines] > > That's it. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.