Results 1 to 3 of 3
  1. #1
    ali_sh is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2019
    Posts
    21

    Add row number to report

    Hello
    What is the simplest way add a row number to report?
    Is there any way to do this without using vba?
    thanks in advance

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    Yes, in the report query, add a hard code field: 1
    ...select *,1 as Countr from table.

    then in the report , set the property of this field to Running Sum.
    it will be your row counter.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870

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

Similar Threads

  1. Replies: 2
    Last Post: 06-13-2019, 07:15 AM
  2. Report gives ID number instead of value
    By moocho992345 in forum Reports
    Replies: 2
    Last Post: 04-11-2016, 11:42 AM
  3. Report Showing ID number and not the name
    By tipopilotas in forum Reports
    Replies: 11
    Last Post: 07-20-2015, 03:21 PM
  4. Report Number
    By cfobare79 in forum Reports
    Replies: 2
    Last Post: 04-06-2015, 04:02 PM
  5. minimum number in report
    By rmiell in forum Reports
    Replies: 2
    Last Post: 10-10-2012, 02:33 PM

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