Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 291
  • Last Modified:

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

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
tawalsh3
Asked:
tawalsh3
1 Solution
 
jadedataMS Access Systems CreatorCommented:
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
 
wblakelyCommented:
With the report open in design mode, Select
- File
- Page Setup
- Columns
- Across, Then Down
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now