Filling rotation fields on a report

[Pret]

I have a query which selects 16 students from a registration list for a
two-day class I run. Part of the course involves hands-on skills rotations
(for example, four groups of four students, rotating thru four sixty-minute
stations over a four-hour span). Is there some way I can construct a grid
on a report which displays the rotations (time intervals on one axis, skills
station names on the other, and names of group members filling the various
rotations?

I'm not afraid to learn some new VBA approaches; but I'm really not very
bright, so be patient with me.

Pret

 

[Duane Hookom]

Do you have the schedule calculated in a schedule? Is the presentation the
remaining issue?

 

[Pret]

The schedule is static from course to course, so I haven't done much besides
design a report with an empty grid, built exclusively with labels at this
point. It was so cumbersome an undertaking that I'm sure it was the wrong
approach, but I was hopeful there'd be some nifty query I could write to
populate the rotation grid, then just put bound text boxes in their
appropriate spots on the grid.

Clear as mud, I know.

Do you suggest that the rotation schedule have its own table, and then
assign students from there?

Sorry I'm a doofus.

Pret

 

[Duane Hookom]

I suggest you first have a table or query that outputs the student, time
period, and station. Once you have that, the display might be tricky but
shouldn't be an issue.