Report with Sub reports - not printing organised by record (PLEASE HELP!!!)

  • Thread starter Colin_S via AccessMonster.com
  • Start date
C

Colin_S via AccessMonster.com

I have a report with various sub reports which totals at 10 pages.

I pull information from a table to complete this report and have about 100
records. The report sorts itself so that i have the 100 different records of
the first sub report, then 100 different records of the next sub report .....


Rather than printing sub report 1 of record one, then sub reports 2 of record
1.... sub report 9 of record 100, sub report 10 of record 100 it prints sub
report 1 of record 1, sub report 1 of record 2..... sub report 10 or record
99, sub report 10 of record 100.

I then have to make 10 piles on my desk and manually sort each record into
it's 10 page report.

Please, please help, this is a total nightmare. I want it to print the full
10 page report for each record.
 
Top