Report Layout Issue - Listed data??

[jcjanssen]

Firstly, apologies for the title of this post. I wasn't sure how to word this issue.

I am currently organising dinner tables for a formal event using access. My Allocations Table has the names of the 5 people on the table, the first and last name of the table captain and their contact number. I would like to create a report with a slightly different design and I'm unsure how to do it.

Currently when I use the Report Wizard, the data is displayed like this (using full text for the purposes of this forum):

Table Captain First Name | Table Captain Surname | Table Captain Contact Number | First Table Member | Second Table Member | Third Table Member | Fourth Table Member | Fifth Table Member

as columns. However, I would like the data to be organised in a row formation like this:

Table Captain First Name
Table Captain Surname
Table Captain Contact Number
First Table Member
Second Table Member
Third Table Member


Fourth Table Member
Fifth Table Member

From there, I would like to print the report out so that there would be about 3 listed records (tables) horizontally and approx. 5 records vertically so there would be 15 records on an A4 sheet. Given that there are over 50 tables, the fewer sheets the better for records. (see image below to give you an idea)



Apologies if this is blatantly obvious / difficult or confusing!! - Reports aren't my strength in Access.

Thanks in advance

Jordan

[June7]

Looks like a multi-column page setup. Open report in design view and set multiple columns from the PageSetup tab. Access Help should have guidelines.

Rearrange the textboxes in the vertical orientation. If you used wizard to create report, the controls are probably all 'grouped'. Select all the controls, right click > Layout > Remove. Now you can move and resize as you wish.

[jcjanssen]

Thanks so much!

Worked perfectly!