two page report with different data layouts

[buratti]

I have a 2 page paper form/report (however you want to categorize it) that I manually have to fill out and submit every month. I am trying to digitize this process using Access but am having difficulties. This paper form is actually pretty simple. The top third of both pages contain just static information like company name, address, phone and etc. The "detail" section of page 2 is basically laid out like a crosstab query. The only data involved in page 1 is grand totals from the crosstab query on page 2, plus an additional calculation.

I have come up short handed on ideas on how to create an Access report in this specific format. I was thinking along the lines of scanning these pages and attaching them as an image in the report and just overlay the data on top of in in the appropriate locations. But this is proving to be difficult as I am getting a whole new page with each new record of data, yet alone was able to figure how to get a different "format" of data on the second page.

Completely recreating the paper form as an Access report is not "impossible" but would prove to be difficult with the limited formatting capabilities of Access reports.

Does anyone have any suggestions on how I could create a report like this that can be printed with 2 different pages. As stated, page 1 is just a total of the data in page 2 so the actual order of the pages laid out on screen or printed is not a big deal. I'm open to all suggestions. Thanks

 

[llkhoutx]

Use 2 subreports, separated by a page marker, with the same header to display your data.

 

[buratti]

Thanks for a suggestion. I've been tinkering with this all weekend, but still cant seem to figure it out. I was originally having trouble getting the layout correct for just one page, yet alone figuring out the two page report. The way I figured out the layout of the one page is that I just imported that scanned page as a background image and adjusted my page headers, footers and detail section accordingly. It took a lot of fine tuning but I finally got everything lined up correctly.

I then used your suggestion to use two subreports, one for each page of the paper form, using the report already created explained before, but that messed up my whole formatting on the page I finally got lined up correctly. When I insert the preformatted report as a subreport, I loose the page header/footer sections of that subreport, and hence, the formatting on those sections.

The header of each of the paper forms hold similar data, but are laid out differently, so placing that data on the header of the "main" report would not work. I have attached a .pdf of the actual paper forms so you may be able to get a better understanding of what I am trying to accomplish. please look at the markups in the .pdf to help understand everything