Report Paging

  • Thread starter Thread starter Sara
  • Start date Start date
S

Sara

I have a report that has at least 60 detail lines (the
daily number can fluctuate; the total number could grow at
any time) and 32 columns. I want it to print on 4 pages:
P1 Columns 1-16 and rows 1-45
P2 Columns 17-32 and rows 1-45
P3 Columns 1-16 and rows 45-end
P4 Columns 17-32 and rows 45-end.
Right now, I have it in 2 separate reports: 1st half does
pages 1 and 3; 2nd half does pages 2 and 4.

Is there any way to have the report in Access 2000 set up
to know to go to another page after column 16? It seems
to already know how to go to another page when the bottom
is reached.

Thanks,
Sara
 
Sara said:
P1 Columns 1-16 and rows 1-45
P2 Columns 17-32 and rows 1-45
P3 Columns 1-16 and rows 45-end
P4 Columns 17-32 and rows 45-end.
Right now, I have it in 2 separate reports: 1st half does
pages 1 and 3; 2nd half does pages 2 and 4.

Is there any way to have the report in Access 2000 set up
to know to go to another page after column 16?
Click to expand...
Can you add a calculated field to your query to designate which page each
detail line should appear on? Then you can group by this field with a new
page on each break.
Jack Peacock
 
Back
Top