<div>
With the report open in design mode, Select<br />
- File<br />
- Page Setup<br />
- Columns<br />
- Across, Then Down
</div>


With the report open in design mode, Select
- File
- Page Setup
- Columns
- Across, Then Down

<div>
<div class="content wysiwyg-content">
I am creating a report in MS Access 2000 and would like to have multiple columns on the report. &nbsp;For example, I have several hundred records for field named &quot;Account Number&quot;. &nbsp;Right now, I can pull account number into the detail section in the design view of the report. &nbsp;The number of records forces the report to be multiple pages. &nbsp;I would like the report to display the recordsto the bottom of the page, then go back to the top and a little to the right and display the next record. &nbsp;In essence I would like to parralel columns on the same page of the same field where the records continue from one column to the next. &nbsp;For example,<br />
<br />
Column 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column 2<br />
Account Number &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Account Number (cont.)<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5<br />
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6<br />

</div>
</div>


I am creating a report in MS Access 2000 and would like to have multiple columns on the report.  For example, I have several hundred records for field named "Account Number".  Right now, I can pull account number into the detail section in the design view of the report.  The number of records forces the report to be multiple pages.  I would like the report to display the recordsto the bottom of the page, then go back to the top and a little to the right and display the next record.  In essence I would like to parralel columns on the same page of the same field where the records continue from one column to the next.  For example,

Column 1                        Column 2
Account Number              Account Number (cont.)
1                                    4
2                                    5
3                                    6


MS Access Reports: Multiple Columns on one page for same field

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.