First, I am more than rusty.
Second, I am more experienced with Access 2000 and earlier than this modern ribbonised fluff.
I want to make a multi-column sub-report with one row and five columns that is printed twice on the master report, and I want the sub-report fed by a code generated record set. My first step was to create the sub-report fed by a test table with similar data. I set the column parameters in Page Setup.
The report would not show as columns in Report View. I did see the columnised output in Print Preview (perhaps that was the same in older Access). The first page was correct, but subsequent pages had the first iteration at a slightly higher position than the rest.
The base unit consisted of three controls: one fed from a record set, one with a constant value (to be set programmatically in the future), and one with a calculated value from the first two. The height of the detail was set to ensure that the second printing on the master report would be at the correct position. At some point, the report ceased to show any part of the sub-report in Print Preview or Report View.
I would sincerely appreciate any assistance and advice in this matter. Thank you in advance.
Second, I am more experienced with Access 2000 and earlier than this modern ribbonised fluff.
I want to make a multi-column sub-report with one row and five columns that is printed twice on the master report, and I want the sub-report fed by a code generated record set. My first step was to create the sub-report fed by a test table with similar data. I set the column parameters in Page Setup.
The report would not show as columns in Report View. I did see the columnised output in Print Preview (perhaps that was the same in older Access). The first page was correct, but subsequent pages had the first iteration at a slightly higher position than the rest.
The base unit consisted of three controls: one fed from a record set, one with a constant value (to be set programmatically in the future), and one with a calculated value from the first two. The height of the detail was set to ensure that the second printing on the master report would be at the correct position. At some point, the report ceased to show any part of the sub-report in Print Preview or Report View.
I would sincerely appreciate any assistance and advice in this matter. Thank you in advance.