Automating a report in Access with multiple dynamic rows in the Header.

[JORGE DIAZ]

This is the format of the report:

Project Name............Proj1...Proj2...Proj3...
Project Complete......10/5....11/27...12/2...
Count of Parts...........2.........2........3...

PARTS...City..State
Part1.....xxx...IL........9/22..............12/2
Part2.....xxx...VA................10/15
Part3.....xxx...NC............................9/8
Part4.....xxx...NY................11/27
Part9.....xxx...CA.......10/5..............11/15

I have the 7 columns (6 in red, 1 in blue) of this Crosstab in one single Access table.

Project Complete: Is the MAX date of completion from all Parts in the Project.
Count of Parts : Is the # of processes in that Project (It just counts the existing dates)

The number of Projects varies from week to week, from 3 to 20, as well as the Parts and Dates.
How I can do an automated report in Access with multiple dynamic rows in the Header? that is with: Project Name; Project Complete and Count of Parts



Thanks!
Jorge

[June7]

Not easily. Review http://allenbrowne.com/ser-67.html

I have a solution in my db that involves a lot of VBA writing records to temp table. https://www.accessforums.net/program...ias-21972.html