Results 1 to 3 of 3
  1. #1
    New Lounger alexpereira's Avatar
    Join Date
    Aug 2003
    Location
    Washington, District Of Columbia, USA
    Posts
    15
    Thanks
    1
    Thanked 0 Times in 0 Posts

    record numbers in reports (access 2000)

    I have a table with, let's say, 100 entries (names and corresponding data). I want to print a report "A" sorting those entries in alphabetical order.
    In the report, each entry is one page.
    I then want to make an index sheet (report "B") showing the entry name and the corresponding page number, so you can go directly to the page you are looking for.
    The data entered was not originally in alphab. order so I created a query sorting in alphab. order and created report "A" using the query. How do I get the corresponding page numbers to appear in the index report "B"?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: record numbers in reports (access 2000)

    See ACC2000: How to Create a Table of Contents or Index for a Report. This MSKB article contains a description of how to do this, and a link to download a sample reports database that illustrates the technique.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: record numbers in reports (access 2000)

    There is a trick associated with reports that is the most common technique. <!mskb=296245>Microsoft Knowledge Base Article 296245<!/mskb> which is titled "How to Print Line Number for Each Record/Group on a Report" gives you the details - basically, you use the Running Sum property of a control, and start it at 1. Post back if you have trouble making it work.
    Wendell

Posting Permissions

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