Column Breaks

[kldoe]

I have a report with only two fields, i.e. Name and Product. I have hundreds of records which take up many pages. I would like the information to be in 2 columns and at the bottom of first page, to "snake" up to the top right of page one and continue on instead of going to new page. Can't figure out how to. Any suggestions? Thanks

 

[CasperTFG]

This should help: I didn't look into it to much as I usually use Crystal for my reporting but I hope it's helpful.

Create a multiple-column report

1 Create a report.

How?

Notes

· When a multiple-column report is printed, the report header and footer and page header and footer span the full width of the report, so you can place controls anywhere in these sections in Design view.
· When printed, the group header and footer and detail section of a multiple-column report span the width of one column. For example, if you want to print the data in two three-inch columns, place the controls within the width of one column; in other words, place the controls in the first three inches of these sections in Design view.

2 On the File menu, click Page Setup.

Show me

3 In the Page Setup dialog box, click the Columns tab.
4 Under Grid Settings, in the Number Of Columns box, type the number of columns you want on each page.
5 In the Row Spacing box, type the amount of vertical space you want between each record in the detail section.

Note If you left space between the last control in the detail section and the bottom edge of the detail section, you can leave Row Spacing set to 0.

6 In the Column Spacing box, type the amount of space you want between the columns.
7 Under Column Size, type the width you want for a column in the Width box; for example, 3 inches. You can set the height of the detail section by typing a number in the Height box or by adjusting the height of the section in Design view.
8 Under Column Layout, click the Down, Then Across option or the Across, Then Down option.

9 Click the Page tab.

10 Under Orientation, click Portrait or Landscape.
11 Click OK.

For information on starting each group in a new row or column, click . Craig, mailto:sander@cogeco.ca

"Procrastination is the art of keeping up with yesterday."

I hope my post was helpful!!!