Not sure whether this is any help, but if you do a quick check in Northwind of the "Employee Sales by Country" there are sub-group and group totals in each group footer, with different types of calculations. I don't think any of these have a Count function, but if you put the Count in your query & just Sum it in your group footer...? Apologies if i've misunderstood.