Turn report into a book

[Phil]

I am trying to turn a a report printed in 2 columns on A5 paper into a
booklet. The report is basically names & addresses and the report I am
interested in takes 5 columns on 3 pages.

So I accept the fact that I have to make the booklet 4 pages long with 8
columns.

The problem is that for example, assuming the names are printed out
alphabetically, the first block of names must appear in the right hand column
of page 1, while the left hand column(last page in booklet) is blank.
Similarly the next block of names appears in the left hand column of page 2
while the right hand column, page 7, is blank. I won't go on, 'cause it gets
very confusing Any bright ideas how to achieve this.

Thanks

Phil

[Salad]

Don't know if this will help but you might want to look at
MoveLayout, NextRecord, PrintSection Properties. Perhaps
If [Page] Mod 4 = 0 then
Me.NexdRecord = False
Else
Me.NextRecord = True
ENdif
Most likely it will require some futzing.

The following didn't come over formatted but it provides the truth table.

MoveLayout NextRecord PrintSection Description
True True True (Default) Move to the next print location, get the next
record, and print the data.
True False True Move to the next print location, don't advance to the
next record, but print the data. This combination is typically used when
the data in a section requires more space than the layout allows and you
want to print the remaining data in the space that would otherwise be
occupied by the next section.
False True False Skip a record without leaving a blank space on the page.
True True False Skip a record and leave a blank space on the page.
True False False Leave a blank space without skipping a record.
False True True Print the current record on top of the last record as an
overlay.
False False True Not allowed.
False False False Not allowed.

[Phil Stanton]

Thanks, Salad.

At least that may start me off

Phil
"Salad" <sa...@oilandvinegar.com> wrote in message
news:ipKdnQdZZ-hTf93W...@earthlink.com...

[Salad]

Phil Stanton wrote:
> Thanks, Salad.
>
> At least that may start me off

I didn't then, still don't, understand your issue. Have you also looked
at Sorting & Grouping as well? Maybe setting the GroupOn to Prefix
characters and Group Interal to 1 might help, setting a footer section
on it, and doing a ForceNewPage after group. I know you won't always
have sets of 3 pages per letter.

[Phil]

Hi Salad. Can't have made myself very clear
If you take a a simple book of say 2 pages printed on both sides on A5
landscape paper, folded in half and stapled together through the center you
end up with what appears as an 8 page A6 Portrait booklet. To do this, the A5
paper has 2 columns on it.

Page 1 of the A6 size booklet Names begining with say A to E have to be
printed on the right hand column of a page, and the last of the names say X
to Z needs to be printed on the left hand column of the same page and would
show as Page 8. On the reverse of that page we need to print the second block
of names (F to I) and label this Page 2 in the left hand column, and the last
but 1 block of names (U toW) in the right hand column which is labelled Page
7. The inner pages need to be treated similarly.
So I know that the sum of the 2 page numbers is 9 so we can deduce that Page
3 (J to L) is on the right of the next sheet and Page 6 (S to To T) is on the
left. This is backed by Page 4 (M to O) in the left column and Page 5 (P to
R) in the right hand column I'm not sure if that is any clearer, the simplest
way to visualise it is to get the paper, fold it in half and do a mockup.

Phil