Counting Groupings

  • Thread starter Thread starter www.ttdown.com
  • Start date Start date
W

www.ttdown.com

Does anyone know of a formula that would count the number of groupings
in a report? I have a report that is grouped by Client Name with
several Invoice Records under each client grouping. When I add an
unbound text box that contains =Count(*) in the header I get the total
number of Invoice records but I would really like the formula to
return the number of Client Name groupings. Thanks!!
 
Add a text box to the Client Name header:
Name: txtCountClient
Control Source: =1
Running Sum: Over All
Visible: No
Then add a control to the Report Footer:
Control Source: =txtCountClient
 
Back
Top