467,141 Members | 1,340 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,141 developers. It's quick & easy.

columns in reports

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
Nov 13 '05 #1
  • viewed: 1251
Share:
1 Reply
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by scorpion53061 | last post: by
1 post views Thread by bobh | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.