Access Report-Summing a field with a group by clause

[mikepf]

My query has a Percent to Totals calculation (w/ group by clause). The report that uses this query prints 3 columns (the item name, "number of rows", and Pct to Total). Now I want to add a Sum("number of rows") to the report footer but am getting "Multi-level group by clause is not allowed in a subquery". Is there a work-around?

 

[genomon]

Can you use the DSum() aggregate function as the data source for a text box?

Money can't buy happiness -- but somehow it's more comfortable to cry in a Corvette than in a Yugo.

 

[dhookom]

This error is generally caused by a subquery in your report's record source. You may be able to use the horribly slow DSum() or similar.

Duane MS Access MVP
Now help me support United Cerebral Palsy

 

[mikepf]

Thanks,I'll try it.