Show All

Count the number of records in each group or report

1. Open the report in Design view.
2. Do one or both of the following:

   Count the number of records in a group

   1. Click the Text Box tool on the toolbox and click the detail section. The control will not be visible to the user, so its placement within the section is not critical.
   2. Select the text box and click Properties on the toolbar.
   3. Set the following properties.

      Property	Setting
      Name	A text string, such as RecordCount
      ControlSource	=1
      RunningSum	Over Group
      Visible	No

   4. Add a text box to the group footer.
   5. Select the text box, and then click Properties on the toolbar.
   6. Set the ControlSource property to the name of the control in the detail section that's tracking the running total; for example, =[RecordCount]

   Count the number of records in a report

   1. Click the Text Box tool on the toolbox and click the report header or footer section where you want to place the text box.
   2. Select the text box and click Properties on the toolbar.
   3. Set the ControlSource property of the text box to =Count(*).

      This expression uses the Count function to count all the records in the report even if some fields in some records are Null.