I have data in Access and can export to Excel. I can create an Access Report
or using Word template and Mail Merge to create the same Access report using
detail data from a query.

I also have an Access report with sub totals at 3 group levels. I am
running the report using a query.

I would like to be able to create the 3 group level report in Excel with
appropriate headings and footings using automation from data created in an
Access query and exported to Excel.

Where should I look to get a description of the terminology, process, and an
example?

Jack