Muitiple column report with one feild

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large single column list that I would like to print off sequentialy per page, one column 1 records 1-40, column 2 records 41 -80 and so on until I need to go to the next page

Thanks in advanc

Office XP pro
 
Andre said:
I have a large single column list that I would like to print off sequentialy per page, one column 1 records 1-40, column 2 records 41 -80 and so on until I need to go to the next page.
Click to expand...


I think all you need to do is use the File - Page Setup menu
item to specify the number of columns and the method of
snaking.
 
I'm trying to do something similar, but I don't think the
Page Setup will work for me. I have upto 4 items of data
in a subform that I would like to be in two columns like
below:

Item1 Item3
Item2 Item4

How can I tell the subform to format with that column
pattern? Now it just goes in one column straight down:
Item1
Item2
Item3
Item4

All help is very much appreciated!
Thanks,
- Anisah
-----Original Message-----
Click to expand...
print off sequentialy per page, one column 1 records 1-
40, column 2 records 41 -80 and so on until I need to go
to the next page.
 
Anisah said:
I'm trying to do something similar, but I don't think the
Page Setup will work for me. I have upto 4 items of data
in a subform that I would like to be in two columns like
below:

Item1 Item3
Item2 Item4

How can I tell the subform to format with that column
pattern? Now it just goes in one column straight down:
Item1
Item2
Item3
Item4
Click to expand...


I hope you mean subreport and not subform.

You can not readily get a subreport's snaking to go Down
then Across. This is because subreports are unaware of page
boundaries so Down then Across just keeps going down and
never figures out that its time to go to the next column.

If you could live with Across then Down snaking, then a
subreport can easily do this using Page Setup. Just make
the subreport **control** wide enough to display both
columns.
 
Marshall,

Thanks for the reply! And yes, I did mean subreport ;-)

Unfortunately, the snaking needs to fit a pre-printed form
and it snakes down and then to the right. Is there any
other fairly easy way to just pull the info from the
Record Source and force the values into fields placed like
I need them? down and then over?Thanks again!
- Anisah
 
Anisah said:
Unfortunately, the snaking needs to fit a pre-printed form
and it snakes down and then to the right. Is there any
other fairly easy way to just pull the info from the
Record Source and force the values into fields placed like
I need them? down and then over?
Click to expand...


No "easy" way. It would require the records to contain a
number(1, 2, ...) representing the order they should appear
in the report. If you don't have that already, it can be
calulated in the subreport's record source query, but you
will have to explain the sort order that determines which
record is Item1, which one is Item2, ... along with the
other details of the query.
 
Back
Top