Autonumber rows in reports

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Denbo
    #1

    Autonumber rows in reports

    Does anyone know how I can print a report that autonumbers each row/record
    it prints. Nothing complicated, just from 1 upwards.


    TIA


    Denis


    Tags: None
    • Rick Brandt
      #2
      Re: Autonumber rows in reports

      "Denbo" <denisfb@optush ome.com.au> wrote in message
      news:3f68592d$0 $20475$afc38c87 @news.optusnet. com.au...[color=blue]
      > Does anyone know how I can print a report that autonumbers each row/record
      > it prints. Nothing complicated, just from 1 upwards.[/color]

      Put a control on the report with =1 as the ControlSource and then set the RunningSum
      property to "Over All".


        Comment

        • Denbo
          #3
          Re: Autonumber rows in reports

          Thank you.


          "Rick Brandt" <RBrandt@Hunter .Com> wrote in message
          news:bk9o9o$qeh nc$1@ID-98015.news.uni-berlin.de...[color=blue]
          > "Denbo" <denisfb@optush ome.com.au> wrote in message
          > news:3f68592d$0 $20475$afc38c87 @news.optusnet. com.au...[color=green]
          > > Does anyone know how I can print a report that autonumbers each[/color][/color]
          row/record[color=blue][color=green]
          > > it prints. Nothing complicated, just from 1 upwards.[/color]
          >
          > Put a control on the report with =1 as the ControlSource and then set the[/color]
          RunningSum[color=blue]
          > property to "Over All".
          >
          >[/color]


            Comment

            • MGFoster
              #4
              Re: Autonumber rows in reports

              -----BEGIN PGP SIGNED MESSAGE-----
              Hash: SHA1

              Hi,

              Use the running sum property of a TextBox. E.g.:

              1. Set up a TextBox where you want the line (autonumbers) to appear
              (usually in the Detail section).
              2. Set the RunningSum property = OverAll
              3. Set the ControlSource = "=1" without the quotes.

              Each time the detail (or whatever section you selected) prints the
              number will appear. The next line will increment the number by 1.

              See the Access help topic on Running Sum.

              HTH,

              MGFoster:::mgf
              Oakland, CA (USA)

              -----BEGIN PGP SIGNATURE-----
              Version: PGP for Personal Privacy 5.0
              Charset: noconv

              iQA/AwUBP2pciYechKq OuFEgEQIpBgCg2r lxfQe/gIkHqO9wuPRny6h oy2kAoI60
              R/f+X6U0SaqASWxRs 1BiA20d
              =qFR8
              -----END PGP SIGNATURE-----


              Denbo wrote:[color=blue]
              >
              > Does anyone know how I can print a report that autonumbers each row/record
              > it prints. Nothing complicated, just from 1 upwards.
              >
              > TIA
              >
              > Denis[/color]

                Comment

                Previous template Next
                Working...