MS Access Report Format

[Guest]

If you set the length of a report so that three pages will fit on a sheet of
paper the first sheet of paper will have 1st page on the top of the 1st sheet
2nd page in the middle of the 1st sheet and the 3rd page on the bottom of the
first sheet then the 4th page will be on the top of the 2nd sheet of paper
and so on, but what I need is if there are 30 pages then the 1st through 10th
page would be on the top of 10 sheets of paper then 11 through 20 would be in
the middle of the 10 sheets of paper and 21 through 30 would be on the bottom
of the 10 sheets of paper, this is perforated paper and I wish to tear the
top off in one tear stack it on the top of the middle then tear off the
middle in one tear stack it on the top of the bottom and have everything in
order, any help would be appreciated...

 

[Sylvain Lafontaine]

Rebuild your query so that pages 1,2,3,4,5,6,7,8,9,10,
11,12,13,14,15,16,17.... become 1,11,21, 2,12,22, 3,13,23, ....

One easy way would be to add a field and enter the value 1 to page 1, 11 and
21, then the value 2 to pages 2, 12 and 22 and so on; then you order your
report with this field.

S. L.

 

[Larry Daugherty]

Hi David,

I responded to your post of 5 Jan 2005 in this newsgroup on this issue. You
never continued the dialogue in that thread but started this new thread. I
made some suggestions in the other thread. Did you ever read my response?
How does what was suggested there not fit your needs?