Subreports side by side

[coach32]

I need a report that shows data in the following format
0-7 8-14 15-21 22-28 29-60 61-90 >90
1743 6 5 15 29 12 13 8
1744 7 3 18 45 15 12 9

I have a query for each time period (eg: 0-7, 8-14 etc.) and the queries count the totals for just 14 Teams. My question is, how do I get each report that I have created for each time period, to sit side by side on a main report? Thank-you for any assistance.

[June7]

You have 7 queries and 7 reports? I am sure there must be a better way.
Show the SQL statement for one of the queries. Show sample of the source data.
A cross-tab query might work.

Otherwise, create subreports on a main report and arrange them as you want. Good luck getting the team records to line up. They won't if any doesn't have data for a period.

[alansidman]

cross post http://www.access-programmers.co.uk/...d.php?t=215908

http://www.excelguru.ca/node/7