Count Group in Group or Report Header

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I count the number of occurances of a group in the Group or Report
Header?
 
How can I count the number of occurances of a group in the Group or Report
Header?
Click to expand...

In the Group header add an unbound text control.
Set it's control source to:
=Count(*)

The same control placed in the Report header or footer will return the
count of all records of all the groups.
 
Let me clarify. I want this control to total the number of occurrences of
that Grouping. =Count(*) counts the groups running over the report and does
not show the total till the last occurrence. I would like to put the total
count in the Report Header so I can see the total without turning to the last
page. Total of Group not total of records (just for further clarification)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Group Count in Parent Group Header 2
Group Count of Dates (No Duplicates) 3
How to count records using count(*) in a chart report 3
Count Number of Subgroups in Group Header 3
Group Header missing 2
Count records, but not dupes 15
group header on the whole report 2
Count/Dcount and Group Header 4

Back
Top