Grouping records on separate report pages 1

[BrianLe]

I'm trying to create a report from the records in a query (qryReqReadDocs). The fields are GroupID, EmployeeID, TopicID, and SubjectID, as well as description fields for each. Each EmployeeID is assigned to a GroupID, and each SubjectID is assigned to a TopicID. There are typically 5-10 employees in a group, and 1-5 subjects for the same topic.

For the report, I would like one page for each GroupID. On each page would be a list of the TopicID's and their SubjectID's , and a list of the EmployeeID's in the GroupID.

I have tried various grouping properties and sub-reports. The sub-reports seem to be the way to go, but I can't figure out how to get one page for each GroupID. I get a separate page for each record in the query.

Any suggestions?

Thanks,

Brian

 

[dhookom]

Have you considered using a Page Break control at the very bottom of the GroupID footer section?

Duane
Hook'D on Access
MS Access MVP