Hello,
I need assistance. I am building a report in Access and I want to display one of my query results in a multiple columns in a snake format. I have created a report and added the desired number of columns I wanted to see. This method works fine in print view, but it does not stay in this form when I try to add the report as a sub report. I tried using the "top result" feature but I don't know how to select records x to y for the next column. Below is what I want to achieve. I just want to divide my data in multiple columns.
Id
5511
5512
5513
5514
5515
5516
5517
5518
ID ID ID
5511 5515 5519
5512 5516 5520
5513 5517 5521
5514 5518 5522
I need assistance. I am building a report in Access and I want to display one of my query results in a multiple columns in a snake format. I have created a report and added the desired number of columns I wanted to see. This method works fine in print view, but it does not stay in this form when I try to add the report as a sub report. I tried using the "top result" feature but I don't know how to select records x to y for the next column. Below is what I want to achieve. I just want to divide my data in multiple columns.
Id
5511
5512
5513
5514
5515
5516
5517
5518
ID ID ID
5511 5515 5519
5512 5516 5520
5513 5517 5521
5514 5518 5522
Attachments
Last edited:
