Need help adding serial no. in MS Access report

Discussion in 'Software Q&A' started by yogeshm02, Nov 29, 2006.

Thread Status:
Not open for further replies.
  1. yogeshm02

    yogeshm02 Guest

    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
     
  2. mod-the-pc

    mod-the-pc Back to School Mr. Bean !

    Joined:
    Apr 1, 2004
    Messages:
    344
    Likes Received:
    5
    Trophy Points:
    18
    Location:
    Chennai
    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 !!!
     
  3. OP
    OP
    yogeshm02

    yogeshm02 Guest

    Hi!

    Thanks for the reply. Looks a very simple answer, no. :cool:
    Had to check in other computer, so the delay in responding (I have no MS Office at home).

    Thankyou very much.
     
  4. spp_itim

    spp_itim New Member

    Joined:
    Dec 4, 2006
    Messages:
    53
    Likes Received:
    0
    Trophy Points:
    0
    -------------------------------------------------
    That's cool, it works! I too wanted it to know. Thanks.....
     
Thread Status:
Not open for further replies.

Share This Page