Counting Records per group header in Report

  • Thread starter Thread starter karlmcauley
  • Start date Start date
K

karlmcauley

Hello,

I have a report with a group header with several fields being returne
per group header. I want to be able to count the number of record
being returned per group header change.

I have tried the basic count of the field e.g.

=count([Combined_Family_ID]), but this counts all records regardless o
the group header. The group header is Alloc_Code so for each change i
Alloc_Code i need to count the number of Combined_Family_ID's withi
that range.

Note that Combined_Family_ID field is numeric so i cant sum it to fin
the record count!!

Do i use the dcount?

Any help would be appreciated.

Cheers

***********Sorry i was being thick*************all i had to do wa
place the count in the group footer!!!!*********
 
karlmcauley said:
I have a report with a group header with several fields being returned
per group header. I want to be able to count the number of records
being returned per group header change.

I have tried the basic count of the field e.g.

=count([Combined_Family_ID]), but this counts all records regardless of
the group header. The group header is Alloc_Code so for each change in
Alloc_Code i need to count the number of Combined_Family_ID's within
that range.
Click to expand...


Add a text box named txtGroups to the group header or
footer. Set its control source expression to =1 and
RunningSum property to Over All.

You can now use a text box with the expression =txtGroups
in the report footer to display the number of groups.
 
Back
Top