Hello all,
First visit to the site. I usually try to figure my own things out, but have been
absolutely stuck on this problem. The root (I think) is in the detail section.
Supposedly, 1 detail section is printed out for each record in the report. Quick version ... is there any way to change that behavior? I.e. printing all records from a form in just 1 detail section?
Long version:
I have a form for my data. That form has a sub-form. If the sub-form only has 1 record in it, I'm golden. If, however, that sub-form has 2 or more records... I run into some problems. I figured out how to get all the records to show, that's fine. My issue is that the report is creating multiple pages; 1 for each record.
Basically I have:
* A page header, for the top of each page [this works]
* A detail section, to print some information from the form [this ... kind of works]
* A page footer, for the page numbers [this works]
* A report footer, which contains more information from the form.. but we only want to show up once; on the second (last) page. [this works]
The last page works fine. The page header shows up. The page footer shows up. The report footer shows up.
The first page also sort of works (goal is just 2 pages), but then there are middle/duplicate pages based on how many records there are. So if there is one record - there are two pages. Two records = 3 pages. Three = 4, etc.
I understand the reason behind this ... and that is because Access makes one detail section for each record. I just have no idea how to condense it into only one page. I'm thinking that might have been a bit confusing to make sense of ... I'll try to whip up a picture to show it better. Looks like the picture was downsampled ... hopefully it's readable.
First visit to the site. I usually try to figure my own things out, but have been
absolutely stuck on this problem. The root (I think) is in the detail section.
Supposedly, 1 detail section is printed out for each record in the report. Quick version ... is there any way to change that behavior? I.e. printing all records from a form in just 1 detail section?
Long version:
I have a form for my data. That form has a sub-form. If the sub-form only has 1 record in it, I'm golden. If, however, that sub-form has 2 or more records... I run into some problems. I figured out how to get all the records to show, that's fine. My issue is that the report is creating multiple pages; 1 for each record.
Basically I have:
* A page header, for the top of each page [this works]
* A detail section, to print some information from the form [this ... kind of works]
* A page footer, for the page numbers [this works]
* A report footer, which contains more information from the form.. but we only want to show up once; on the second (last) page. [this works]
The last page works fine. The page header shows up. The page footer shows up. The report footer shows up.
The first page also sort of works (goal is just 2 pages), but then there are middle/duplicate pages based on how many records there are. So if there is one record - there are two pages. Two records = 3 pages. Three = 4, etc.
I understand the reason behind this ... and that is because Access makes one detail section for each record. I just have no idea how to condense it into only one page. I'm thinking that might have been a bit confusing to make sense of ... I'll try to whip up a picture to show it better. Looks like the picture was downsampled ... hopefully it's readable.
