View Single Post
  #1  
Old January 15th, 2010, 06:11 PM posted to microsoft.public.access.reports
Gabe
external usenet poster
 
Posts: 83
Default # of subreports in 1 main report?

Is there a limit to the amount of subreports you can put in 1 main report?
I'm using Access 2003. I have like 92 subreports I need in 1 report...or
maybe I'm doing it wrong.

Each subreport is tied to query that filters for division sections based on
a 3 digit code assigned to the section (RDC). So we have like 92 division
sections, for example RDC code 100 - 199 is all Admin, while RDC 200 - 299 is
all Operations, etc...So it comes out to like 92 different sections, I would
like to be able to print them all out at once from 1 main report with each
section on a seperate sheet, but I'm not sure if I can get 92 subreports in 1
main report.

Thanks,
Gabe