Solved

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

Posted on 2004-08-19
2
284 Views
Last Modified: 2013-11-28
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
0
Comment
Question by:tawalsh3
2 Comments
 
LVL 32

Accepted Solution

by:
jadedata earned 250 total points
ID: 11844184
Greetings tawalsh3!

  Use the column settings of the report format in design view to specify how you want this to look.
  Practice is what it will take.

regards
jack
0
 
LVL 2

Expert Comment

by:wblakely
ID: 11844449
With the report open in design mode, Select
- File
- Page Setup
- Columns
- Across, Then Down
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question