multiple column report using two fields? 1

[legos]

i have a report that has 4 columns that show data from two fields (each column has 2 textboxes that are linked to two fields). the report is linked to a table that has alot of records (a thousand or so). how do i make it so the first column displays the field valuses for the records 2-32, the second column displays the records 33-63, the third 64-94, and the forth 95-125. Then on the next page it continues with the first column displaying 126-156 and so on. It might be helpful that one of the two fields values change in increments of 5. so the value of the second record is 0, the third 5, the 11th is 50.

Durible Outer Casing to Prevent Fall-Apart

 

[comaboy]

Easy!

Ensure your report width is less than 1/4 of the paper's page width, go to Print Setup, Click the "Columns" tab and slap 4 into the Number of columns box.

Then choose "Down, then Across" in the Column Formatting options and click OK.

Job done!

 

[legos]

thaks alot, never would have thought of that

Durible Outer Casing to Prevent Fall-Apart