Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Line numbers

Discussion in 'Information Technology' started by Rich Mogy, Jul 28, 2006.

Tags:
  1. Rich Mogy

    Rich Mogy
    Expand Collapse
    Guest

    Hi All,
    I would like to create a report that assigns a line number to each row in
    the report, starting with 1 and incrementing by 1.

    Please.

    RM
     
  2. Loading...

    Similar Threads Forum Date
    Khalsa Aid The Selfless Sikh Faith On The Frontline, A Documentary By BBC 2016 Sikh Organisations Nov 16, 2016
    Sikh News Veteran Sikh Soldiers To Inspire Young - Malay Mail Online Breaking News Aug 1, 2016
    Hard Talk Confused Islamophobes Target American Sikhs Online Hard Talk Apr 26, 2016
    Is There A Thin Line Between Love And Hate? Interfaith Dialogues Apr 25, 2016
    Hard Talk Taking One Liners Out Of Context From Gurbani To Allow Intellectual Independence? Hard Talk Apr 23, 2016

  3. fredg

    fredg
    Expand Collapse
    Guest

    On Fri, 21 Jul 2006 20:54:15 GMT, Rich Mogy wrote:

    > Hi All,
    > I would like to create a report that assigns a line number to each row in
    > the report, starting with 1 and incrementing by 1.
    >
    > Please.
    >
    > RM


    Add an unbound control to the detail section
    Set it's control source to
    =1
    Set it's Running Sum property to
    Over all
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  4. CharlesGuzman@gmail.com

    CharlesGuzman@gmail.com
    Expand Collapse
    Guest

    You could be creative i guess and do it this way:

    1. Create a table called Numbers or something with an autonumber and a
    field titled Blk
    2. Write a query to append 10,000 rows or whatever amount you need by
    appending the value Null to the field Blk(probably a couple hundred
    extra depending on the size of your database)
    3.Create a macro called macro1. In macro1, use the openquery value and
    type in the name of your append query.
    4.Create a macro called macro2. In macro2, use the 'runmacro' feature
    and set the account to 10,000 or whatever the number was you wanted it
    to append.
    3.Then, in the report datasource, include the Numbers table and it's
    autonumber.
    4. In the report, make a text box with the control source as the
    autonumber. Make sure that in the report datasource that the Numbers
    table is not linked to any other table yet. This little text box will
    be your line number.

    Note: to ensure that you only get the amount of lines you need, now you
    may link the autonumber in the Numbers table to the ID of the item
    you're reporting on. The use the 'group by' function so you dont start
    to get duplicate records. Still need help? write back here or email
    me at charles guzman at gmail dot com.

    Chuck




    > Hi All,
    > I would like to create a report that assigns a line number to each row in
    > the report, starting with 1 and incrementing by 1.
    >
    > Please.
    >
    > RM
     

Share This Page