Results 1 to 2 of 2
  1. #1
    LanieB is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2011
    Posts
    54

    Wink Autonumber in front of records in a report


    Hello Everyone!

    I can not figure out FOR THE LIFE OF ME how to put an 'autonumber' in a report. Each records shows up one after the other and I want there to be a 1. 2. 3. etc. in front of them so the branches can see their 'ranking'. I saw the COUNT RECORDS option which will give me the total number. But what do I need to add to make it do a sequential numbering? THANK YOU!!

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    Put a textbox in the detail section and make its control source:

    =1

    and set its running sum property as appropriate.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 01-04-2012, 01:39 PM
  2. Getting report to be displayed in front of Menu?
    By newtoAccess in forum Forms
    Replies: 3
    Last Post: 12-28-2010, 11:06 AM
  3. Inserting records into tables with autonumber
    By LAazsx in forum Import/Export Data
    Replies: 1
    Last Post: 12-13-2010, 11:55 PM
  4. Replies: 4
    Last Post: 12-13-2010, 05:33 PM
  5. report opens.. but not to front
    By kroenc17 in forum Access
    Replies: 5
    Last Post: 10-13-2010, 08:42 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums