Using a Single record, need multiple labels

[igel]

Access(r) labelling Report yields one label per record, which works for single-page tags shown in the first & 3rd columns:

(FileNr) 9806-17 9806-18 9806-19
(Sheet) 1 of 1 1 of 3 1 of 1

But for records with more than one page, each sheet needs a label. Help me repeat-print the second record n(3)times:

9806-17 9806-18 9806-18 9806-18 9806-19
1 of 1 1 of 3 2 of 3 3 of 3 1 of 1

This is in a 'labels-report' design, using a query to select new files entered after a prompted date. I use '[Total Sheets]' for the last number of the set.
Should I append the query, make a new query, or make a macro? Instructions may flow similar to the following...

set variable Tally = 0
begin loop
Talley = Talley + 1
if Talley > [Total Sheets], stop loop
else print FileNr, Tally, and [Total Sheets]
end loop
end
(print next record)

Any suggestions?
j2




[Total Sheets]