Appending Consistent Number of Blank Rows to Report

[zmbd]

So, I have the thread:
Has Anyone Attempted a Report for a Class Attendance Log?

I've managed to get the format... however, I decided that I would like to append enough rows so that that there are a total of thirty rows - easy enough - problem with the sorting with the null records first, I can kludge that for now...

Then I thought, why not add teachers in to the mix, group the report on teachers and we're good to go - well not exactly - the first attempt resulted in a Roster page of blank rows followed by pages for each teacher without the blank rows (just student names). Of course, grouping by teachers in the report and I pulled a null field for the teachers:
(1st query)

SELECT [StudentList].[ID], [StudentList].[LastName]
   , [StudentList].[FirstName], [t_teacher].[Teacher_Name]
   , [t_teacher].[Teacher_Class]
FROM [t_teacher] INNER JOIN [StudentList] 
      ON [t_teacher].[PK_Teacher] 
         = [StudentList].[FK_Teacher]
ORDER BY [StudentList].[LastName]
UNION ALL SELECT [pk_blank], Null, Null, Null, Null
FROM [t_blank]
WHERE ([pk_blank] Between
       ((((SELECT Count(*)
           FROM [StudentList]) - 1) Mod 30) + 2) And 30);

So my thought was cartesian product against the students table and the blank row table and pull the teacher name field in...
(this is version 5 :) )

SELECT [StudentList].[ID], [StudentList].[LastName]
   , [StudentList].[FirstName], [t_teacher].[Teacher_Name]
   , [t_teacher].[Teacher_Class]
FROM [t_teacher] INNER JOIN [StudentList] 
      ON [t_teacher].[PK_Teacher] 
         = [StudentList].[FK_Teacher]
ORDER BY [StudentList].[LastName]
UNION SELECT [BRow], Null, Null, [Bname], Null
FROM 
   (SELECT [t_blank].[pk_blank] AS [BRow]
   , [t_teacher].[Teacher_Name] AS [BName]
   FROM [t_blank], [t_teacher] 
      INNER JOIN [StudentList] 
         ON [t_teacher].[PK_Teacher] 
            = [StudentList].[FK_Teacher]) AS Q1
WHERE ([BRow] Between
       ((((SELECT Count(*)
           FROM [StudentList]) - 1) Mod 30) + 2) And 30);

I can get the sort right (as I said, it's a kludge method built a second query based on the union query with a calculated field that returns the last name if not null else "zzzz" and sorts on the calculated field); however, the appended rows are not following as expected. The First teacher will have the students followed by enough blanks to make up 25 rows and the next teacher will have a total of 16 rows the third teacher might have 9 rows total without any blanks.

What am I missing here?

Tables
[Students] (FK to [Teachers])
[Teachers] (FK to [Classes])
(each teacher teaches a single class for now :) )

[jforbes]

I may seem like a copout, but I would create a Temp Table and build a VBA routine that fills out the Temp Table including blank rows where needed.

Unions are just not Access' strong point. Plus I think it will be easier to maintain/update, like when you get a teacher teaching multiple classes.

[zmbd]

+ J, that may not be a copout on this situation.
However, I can set the union up to filter by teacher and then feed the report. TempVars work here very well for the source query and then VBA to drive the reports.

I was just hoping that there was a pure SQL approach to this as I have a few databases that I might be able to apply a similar concept for the reports. :(

+ Fortunately, there should not be a situation where a teacher has more than one class in a given year. However, just as a hobby, I'm building the entire thing out a bit more than I had originally intended. The database started out as a record source for a Word-Mailmerge document and I started thinking that I could combine the Workbook, Word Doc, and the database in to just the database - and the project has grown from there :)