Counting the number of 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!!
 
Hi,


SELECT COUNT(*) FROM (SELECT DISTINCT ClientName FROM myTable) As z


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top