MS Access 97 Report dynamic multiple pages multiple column

[rob2005]

Hi,

I have a question:
- I have a dynamic report with more columns to diplay than is possible on an A4 landscape.
How to solve the problem that on the even pages de rest of the columns will be displayed before continuing with new records?

 

[dhookom]

If you make the page wider then the extra stuff on the right will print following the stuff on the left.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[rob2005]

That is not exactly what I want.
I want to repeat 3 fields (the same from the odd pages) and place only the dynamic column which couldn't diplay on the odd page.
eg.
page 1:
function1 function 2 function 3
kost1
kost2

page 2:

function4 function 5 function 6
kost1
kost2

 

[dhookom]

I don't understand when you say "repeat 3 fields" and then don't seem to show them on your sample.

You can add a field/text box twice so that it shows on the even page and the odd page.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[rob2005]

Sorry, in this example I only showed 1 item.
thats item: kost(x).
In the example the first 2 records (kost1 en kost2) are shown with function 1, function 2 and function 3 on page 1 and the first 2 records (kost1 en kost2) must be shown on page 2 with the function 4, function 5 and function 6 which counldn't been printed on the A4 paper landscape.

 

[dhookom]

Can you set up your report so the detail section is like below:
[tt]
page 1 Page 2
Col1 Col2 Col3 func1 func2 func3 Col1 Col2 Col3 func4 func5 func6
[/tt]

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[rob2005]

I think were are not talking about the same thing.
It's a crosstab (pivot) query.
Page1
Month1 Month2 Month3
Name1
Name2
etc.

Page2
Month4 Month5 Month6 etc.
Name1
Name2
etc.

Page3
Month1 Month2 Month3
Name11
Name12
etc.

Page4
Month4 Month5 Month6
Name11
Name12
etc.

 

[dhookom]

rob2005,
What happens if you make the page with twice the width of the paper? Add your Name field followed by your first group of month fields. Then add the Name field again just to the right of where your right margin would be normally. Then add your second group of month fields. (just like what I suggested above).

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[rob2005]

Thanks, I will try that.
I will let you if it works.