Number each detail record in a group or report

Microsoft Office Access 2003

Show All Show All

Number each detail record in a group or report

  1. Open the report in Design view.
  2. Click the Text Box tool Button image on the toolbox and click the detail section where you want to add the text box for the number.
  3. Select the text box and click Properties Button image on the toolbar.
  4. Set the ControlSource property to =1.
  5. Do one of the following:

    To number each record and reset the counter to 1 for each group, set the RunningSum property to Over Group.

    To number each record without resetting the counter for each group, set the RunningSum property to Over All.

Note  The Sales by Year report in the Northwind sample database has an example of numbered detail records. To view this report, open the Northwind database in the Samples subfolder of your Office folder, and then open the Sales by Year report in Design view.