How do I stop Access from starting subreport on a new page?

[melodyrae]

Initial disclosure: I took 1 accounting with access class in undergrad 6 yrs ago, where we were offered step-by-step instructions to follow. Currently, I am interning (grad-school) for a small non-profit and should not be left with building an access database, but my one class seems to have made me more qualified than the other employees - & what else are free interns for?

I started with 1 table because it is essentially 1 worksheet that I am entering for many entities. When I hit the 256 column/record limit, I split the table into 4 tables and set up relationships. Now that I have finished the data entry for 1 yr, I am trying to print out a report that includes information from each of the 4 tables.

I made 1 report for each table - most of them only take up 1" of detail space, but the final report - the lowest in the heirarchy -contains all the nitty gritty and uses almost the full 22" of detail space allowed. Including supreports for the upper 3 tables works beautifully. Whever I add the last, long table/report, it always starts the report on a new page, ruining the whole thing.

How do I get it to start on the 1st page? Any help you can offer is much appreciated. Appointing me with this task will certainly get the job done, but has not been the most efficient way to complete this project, as I fumble through Access help.

[nico5038]

I'm afraid your table isn't "normalized" as I never have build tables with 256 columns.

I get the impression that the tables hold fields like:
Jan0101, Jan0102, Jan0103, .....

The proper way would have been to enter the data per date and to use a cross-table query to show it on a report.

I would "limit" your report width by making it (like your tables) into four separate ones.

Nic;o)

[melodyrae]

Thanks for the offer of help. Perhaps I can be more clear so that you are better able to provide direction. I actually seem to have made things worse -now each supreport starts on a new page.

The purpose of the database is to track air emissions violations in the Houston area. The primary table is the Respondent information. The table below that is the Docket summary information where the state finalized enforcement against them. Below that is a table for the worksheet that sums the various air violations and increases or decreases the penalty for past behavior, ect. The final table is the rule violations table - there can be up to 14 violations listed per summary worksheet, and lots of information related to them.

In creating a summary report, the most information I need is from the big rule table - which consumes about 19.25" of detail space. I can get it to begin on the same page as the summary worksheet, if I put the summary worksheet info in the page header, but then that messes up subbing the worksheet report into the two higher reports. If I put all 3 higher reports into the page header and the rules into the detail, it says the page headers are bigger than the paper I am printing on and won't give me a print preview. If I put everything into the detail, which is how I currently have it, each new subreport prints on a new page, even if it only takes up 1/2" of space.

Any ideas on how to fix this so everything starts on the same page, and the overflow of rule violations gets pushed to the 2nd page?

Thanks again.