Your data is structured quite nicely but I can't see how it could be used to build a mail merge report in a single Word document.

I think you can use a many-to-one type merge for one section of the report but needing to start multiple times with each a new filter/output fields is problematic.

A Word-centric method using a 'subreport' concept would be to create a shell document and produce separate mail merge output docs for each of the sections. You can then use IncludeText fields to link to those separate documents. This is probably too labour intensive to use as a realistic option.

I would say that this is a job that Microsoft Access is better suited for with a report comprised of sub-reports.

You could also create a macro to do it all in a single Word document. This macro could create a recordset from the input data and then loop through that to build the various sections.

Do any of those options appeal?

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia