Need help adding serial no. in MS Access report

[yogeshm02]

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: -

[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

 

[mod-the-pc]

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 !!!

 

[yogeshm02]

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.

 

[spp_itim]

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.....