How to begin serial number of the records from 100 in access report?

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

    How to begin serial number of the records from 100 in access report?

    Sir
    I would like start serial numbering from 100 in access report. For example
    100) xxxxxxxx
    101) zzzzzzzz
    102) yyyyyyyyy
    Earlier I asked the same question. Expert Sri Rabbit helped in this regard but there might be some mistake from my side in using his suggestion. Once again I request your help in this regard
    Thank you
  • ADezii
    Recognized Expert Expert
    • Apr 2006
    • 8834

    #2
    1. Create a Text Box in the Detail Section of a Report. For the sake of argument, we'll call it Text50.
    2. Delete the associated Label for this Text Box (Text50).
    3. Set the Control Source of this Text Box '=1'.
    4. Set the Running Sum of Text50 = Over All.
    5. Set the Visible Property to No.
    6. Create another Text Box on a Form (Detail Section) where you would like to see the Running Totals (100, 101, 102, etc.). Let's call this Text Box txtTotals.
    7. Set the Visible Property of txtTotals = Yes.
    8. You can also delete the associated Label for txtTotals if you like.
    9. Set the Running Sum of txtTotals to No.
    10. Set the Control Source of txtTotals =[Text50]+100.

    Comment

    • mb60
      New Member
      • Aug 2008
      • 37

      #3
      Thank you sir
      I got it.

      Comment

      • ADezii
        Recognized Expert Expert
        • Apr 2006
        • 8834

        #4
        You are quite welcome.

        Comment

        • Prakash Gnana
          New Member
          • Jan 2011
          • 25

          #5
          Thanks for info

          Comment

          Working...