columns in reports

[Peter Bailey]

I have a report that gives the classroom and then a list of students in it
for a particular week.

Thats fine if I want just one column with its associated rows of students.

I have been asked to produce it so that it gives multiple columns of five
rows. so:

Classroom xxx

Student id 1 StudentID 6
Student id 2 Student id 7
Student id 3 Student id 8
Student id 4 Student id 9
Student id 5 Student id 10
The amount of students will vary so could have more columns of five.

Cannot think how to do this looked at a columnised report but that didnt
seem to work. I thought perhaps creating queries in small subreports that
give the first five and then so on but not sure if that will work or if
there is a simpler way. perhaps in VB.

Regards in advance
Peter

[Wayne Morgan]

The best I can think of off-hand would be to group on the Classroom, placing
it in a group header. Place the students in the detail section with as many
columns as desired. Set the columns to go "across then down". It will give
as many rows as needed, depending on the number of students in the classroom
and the number of columns (i.e. 10 students, 2 columns will generate 5
rows). In the Page Setup dialog, uncheck the box in the Columns setup for
the column being the same size as the detail. For two columns, it will be
about 1/2 the size of the detail, depending on the Column Spacing [(column
width * number of columns) + (column spacing * (number of columns - 1))
should be the same as the detail's (report's) width].

--
Wayne Morgan
MS Access MVP
"Peter Bailey" <pe*********@andaluz.fsbusiness.co.uk> wrote in message
news:cf**********@newsg3.svr.pol.co.uk...

I have a report that gives the classroom and then a list of students in it
for a particular week.

Thats fine if I want just one column with its associated rows of students.

I have been asked to produce it so that it gives multiple columns of five
rows. so:

Classroom xxx

Student id 1 StudentID 6
Student id 2 Student id 7
Student id 3 Student id 8
Student id 4 Student id 9
Student id 5 Student id 10
The amount of students will vary so could have more columns of five.

Cannot think how to do this looked at a columnised report but that didnt
seem to work. I thought perhaps creating queries in small subreports that
give the first five and then so on but not sure if that will work or if
there is a simpler way. perhaps in VB.

Regards in advance
Peter