Report max length

[RyLane]

Hi,

I'm trying to create a report in Access 2010 but I've reached the maxium 22"" length on my sheet.

It's a training feedback form that gets filled out on InfoPath then dumped into Access. It has the Agents name, date, and projects followed by 10 different evaluation sections. Each section takes up almost have a printed page so when I try to recreate the report to match the form, I can only get about halfway before it's maxed out.

I quickly did a bit of research and found some suggestions based on using subforms and another about creating multiple detail sections on the form.

Not sure where to go from here and which way might be best

Thanks

 

[JHB]

Post your database with some sample data, (zip it).

 

[RyLane]

Unfortunately I can't, do to regulations in my office.

 

[JHB]

Unfortunately I can't, do to regulations in my office.

Okay - then I'll leave it for other members to help you, luck with your project.
Sub reports would be the answer, if your data is normalize in the proper way.