Need help adding serial no. in MS Access report

4 posts · originally from https://geek.digit.in/community/threads/need-help-adding-serial-no-in-ms-access-report.42458/

Hi,

I've created a table in MS Access having two fields name and address. Now I want to generate a report which would give its output as: -

Code:

[FONT="Courier New"]
Sr. No.    Name              Address
-------------------------------------
  1.       Mr. ABC           123
  2.       Ms. YBX           999
  3.       Mr. Zeo           809
[/FONT]

Do anyone has any idea how it can be done?

Thanks

1. Insert a new text box before name in the detail section
2. In the text box properties dialog set the "Control source" to "=1" and "Running Sum" to "Over All"
That's it !!!

Hi!

Thanks for the reply. Looks a very simple answer, no.

Had to check in other computer, so the delay in responding (I have no MS Office at home).

Thankyou very much.

mod-the-pc said:
1. Insert a new text box before name in the detail section
2. In the text box properties dialog set the "Control source" to "=1" and "Running Sum" to "Over All"
That's it !!!

-------------------------------------------------
That's cool, it works! I too wanted it to know. Thanks.....