Results 1 to 6 of 6

Thread: Numbering records in a Report

  1. Apr 28th, 2001, 01:18 AM #1
    ikopanas
    ikopanas is offline

    Thread Starter
    New Member
    Join Date
    Apr 2001
    Posts
    13

    Post Numbering records in a Report

    I use VB6 and report designer my records are like this

    John 35000
    Mary 27000
    Tom 12000

    I d like to get a report like this

    1. John 35000
    2. Mary 27000
    3. Tom 12000

    Can anyone out there help me?
    Thanks in advance
    Yannis
    Reply With Quote Reply With Quote
  2. Apr 29th, 2001, 12:27 AM #2
    ikopanas
    ikopanas is offline

    Thread Starter
    New Member
    Join Date
    Apr 2001
    Posts
    13

    test

    test
    Reply With Quote Reply With Quote
  3. Apr 30th, 2001, 01:20 AM #3
    ikopanas
    ikopanas is offline

    Thread Starter
    New Member
    Join Date
    Apr 2001
    Posts
    13

    ?

    ?
    Reply With Quote Reply With Quote
  4. May 9th, 2001, 03:13 AM #4
    ikopanas
    ikopanas is offline

    Thread Starter
    New Member
    Join Date
    Apr 2001
    Posts
    13

    still hoping for an answer!!!

    Reply With Quote Reply With Quote
  6. May 9th, 2001, 07:53 AM #5
    Pete Rosborough
    Pete Rosborough is offline
    Lively Member Pete Rosborough's Avatar
    Join Date
    May 2001
    Location
    Central NY
    Posts
    68
    Just a thought but have you considered creating a temp table on the fly with an extra "counter" field appended to the beginning and then spinning through the records in the original recordset and inserting them into the new recordset counting all the while? Then you can use the second recordset as your source for the datareport

    Hope this helps
    Real programs don't eat cache.

    Pete
    Reply With Quote Reply With Quote
  7. May 9th, 2001, 11:21 PM #6
    ikopanas
    ikopanas is offline

    Thread Starter
    New Member
    Join Date
    Apr 2001
    Posts
    13

    Cool

    I ll do it if no other option is available. Thanks for the help!
    Yannis
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width