Results 1 to 11 of 11
  1. #1
    Join Date
    May 2006
    Posts
    386

    Unanswered: Can I add number against each Row in a report

    Dear All,
    I have report in my database which produces invoice statements. It get list of invoices in the report absolutely correct BUT I would like to add numbering against each Row. For example: I have got 10 Rows and each one shows single record as below:

    InvNo DateofJob Hour Rate Total
    135 15/09/06 2 20 40
    136 16/09/06 1 20 20
    137 16/09/06 3 20 60

    But I want a number column on the left side of each record so that I know how many statements are there in my report. For example:

    No InvNo DateofJob Hour Rate Total
    1 135 15/09/06 2 20 40
    2 136 16/09/06 1 20 20
    3 137 16/09/06 3 20 60


    and so on.

    Any help would be really appreciated.
    Emal
    Emi-UK
    Love begets Love, Help Begets Help

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372

    Hello Emal!

    Look at "DemoRunningSumA2000.mdb".
    Open Report1, look at RUNNING SUM properties for field Text3.
    Attached Files Attached Files

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi emal

    Easiest way I know is to add a field to your query row source (e.g):
    Code:
    SELECT InvNo, DAteofJob, ...., 1 AS Counter
    FROM MyTables
    Then add the counter field to your report and set the Running Sum property to "Over All".

    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by MStef-ZG
    Look at "DemoRunningSumA2000.mdb".
    Open Report1, look at RUNNING SUM properties for field Text3.
    Pipped at the post and a much better way of getting the initial "1" to increment
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    May 2006
    Posts
    386
    Hi Pootle Flump,
    Thank you very much for your prompt reply.
    Do you mean that I have to add a new field to the table on which the query is based? or can i add a new field in the query without adding a new field in the table?

    regards
    Emal
    Emi-UK
    Love begets Love, Help Begets Help

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I meant the latter but check out MStef-ZGs attachment - it is easier to do this directly in the control source of the text box.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  7. #7
    Join Date
    May 2006
    Posts
    386
    Hi Mstef Z-G

    Thank you very much for your help. It absolutely worked. Perfect. I wish the whole world was as helpful place as members and users of this forum.
    emal
    Emi-UK
    Love begets Love, Help Begets Help

  8. #8
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Highly relevant three year old bump
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  9. #9
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Gah... I wish mods wouldn't make me look retarded ^^
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  10. #10
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by StarTrekker
    Gah... I wish mods wouldn't make me look retarded ^^
    Could you please keep your requests within the realms possibility
    Testimonial:
    pootle flump
    ur codings are working excelent.

  11. #11
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    :O

    That would be realms of possibility.... n00b.



    lol
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •