How to start the record number with 100 in the place of 1 in access report?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mb60
    New Member
    • Aug 2008
    • 37

    How to start the record number with 100 in the place of 1 in access report?

    In my access report the record number is starting from 1. I would like start with 100
    Example
    1. xxxxx
    2.xxxxxx
    but I want to begin with 100

    100.xxxx
    101.xxxx
    102.xxx
    I request your help.
    Thank you
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    Add 100 to the control source that's displaying the record number.

    Comment

    • mb60
      New Member
      • Aug 2008
      • 37

      #3
      sir
      the first record is beginig with 100, but 2nd record with 200, 3rd one with 300
      I want the increment of number as follows
      101, 102,103 etc

      Comment

      • Rabbit
        Recognized Expert MVP
        • Jan 2007
        • 12517

        #4
        Add 100, not multiply. What did you put in the control source?

        Comment

        • mb60
          New Member
          • Aug 2008
          • 37

          #5
          sir
          In the control source of record number I put =100. Running sum ; Over all

          Comment

          • Rabbit
            Recognized Expert MVP
            • Jan 2007
            • 12517

            #6
            That wasn't what I meant. You need to put =[record number] + 100. No running sum. No over all.

            Comment

            Working...