one sub one plus dept

[rob p]

I am working with Access 2002 and pulling in data form sotamas90. My main
report is grouped by dept. I have a dept head / footer and a detail section.
There is an unknown amount of depts or detail records.

I want to have a subreport append itself to the main report after the last
dept in the main report and be part of a grand total. (I got some good help
from Allen B. on how to carry amount from sub to main report..)

I just don't know where to put the subreport.

If I put in in the dept footer, it repeats each dept break. If I put it in
the page footer, it only prints on the bottom of the page and won't work if
it carrys over to another page.
Thanks.

 

[Terry]

Rob,

I would put it in the report footer above any grand totals
you have. This will appear after the last group footer.

If you want a grand total with the sub-report total add
the subreport amount to the main report total.

HTH,

Terry

 

[HSalim]

Try adding a dummy group above department and put this in the dummy group's
footer

HS