If one assumes that this 'print' isn't of an on screen form or to Excel or Word or some other program, then one might assume you are asking about a report, and in the Access world, these is bound to a recordset. Presumably you need a recordset that has a pair of empty rows at the bottom. Let's also assume that you need them sorted by last name. The ususal procedure is to use a Union of SQL clauses where you union a series of SELECT statments. The first SQL statement is, based on your example data with assumptions as to field and table names:
Select FirstName, LastName, Email From tblStudent Order By LastName, FirstName;
You could add a single empty record by adding a single union clause:
Select FirstName, LastName, Email From tblStudent Union Select '', '', '' From tblStudent Order By LastName, FirstName;
(those literals are pairs of apostrophes - single quotes - without anything between them) Unfortunately, the empty record will sort to the top. You can add up to 50 unioned Selects in Access 97 (I am not sure of more recent versions) and you have to specify Union All if you want identical '', '', '' records to appear for each one.
To attack the sort issue, you can select the last name and first name a second time and modify it in some way so that it still sorts the same yet is different from the field values. I like to prefix with a space: ' ' & FirstName As SortFirst for example. You may then specify a literal value which is likely to append the literal after conventional last and first names.
SELECT LastName, FirstName, Email, ' ' & LastName AS SortLast, ' ' & FirstName as SortFirst
FROM tblStudent Union Select '', '', '', 'ZZZ', 'ZZZ' From tblStudent Union Select '', '', '', 'ZZZz', 'ZZZz' From tblStudent
ORDER BY SortLast, SortFirst
Substitute your field and table names and leave out controls for displaying the SortLast and SortFirst fields in your report.
Ciao
Jurgen Welz
Edmonton AB Canada
[email protected]
Printing blank grid in detail section
