footer subtotals with grand totals; use subreport? 1

[jpkent]

I did plenty of searching on this topic here and didn't find anything helpful, or atleast anything I understood.

My problem is, I have a report that displays records by doctor, and within each record for that doctor there are a series of checks. I was able to handle grand totals just fine, but I want to create a subtotal for each doctor's checks in the report's footer.

The doctor will never be a constant value: new doctors will be added and old ones removed; so setting the criteria in DSum to something like "Dr='AAA'" won't do what I need it to do.

 

[dhookom]

If I understand correctly you should create a totals query that is similar to your report's recordsource but groups by doctor and totals the checks. Then, create a subreport that is based on this totals query and place the subreport in the footer of your main report.

Duane
MS Access MVP

 

[jpkent]

Thanks, I didn't think it would be that easy. I just made the report's record source handle all the totals instead of making an independent query. Works all the same.