Printing mailing labels with multiple recipient name records associated with a single address

[Skylark]

I have been browsing this, and other Access groups, as well as some of
the Microsoft KB articles, and while I find posts decribing similar
objectives to mine, can't seem to find anything that specifically
shows me how to solve my problem.

I have a property management database which contains many related
tables, including a table "Units" and a table "Tenants". Tenant
records have a corresponding foreign key for the UnitID relating them
to the Units table. A tenant can only be associated with one Unit
record, but a Unit may be associated with many Tenant records. I need
to be able to print mailing labels, listing all of the tenant names,
with their related Unit address. For example:

Tenants.Name (1)
..
..
..
Tenants.Name (n)
Units.AddLine1
Units.AddLine2
Units.AddLine3

The Mailing Labels wizard won't help me, because that prints a
separate label for each tenant record.

I have tried various things, for example, a multi-column report
grouped by UnitID, with the Tenants.Name field in the detail area, and
the Unit Address fields in the group footer. I get the correct data
this way, but I can't get the data to format correctly for labels.
Since the Tenants.Name detail will vary depending on the Unit I can't
figure out how to fix the report areas.

I am using Avery 5163 4"X2" mailing labels (2 columns, 5 rows on an
8.5" X 11" sheet) with our company logo/return address pre-printed in
the upper left hand corner, which occupies 1.25" X 1" of space on the
label, so my recipient address needs to be positioned on the label
space accordingly.

Any help would be appreciated!

 

[Skylark]

P.S. I have also tried setting up my report with the group footer with
Unit Address information, and Select Distinct Unit as a criteria in
the query that is the record source for the report, and I have a
subreport that simply has Tenant name in the details field. What I am
ending up with is the data displaying as follows:

Tenant (1)
..
..
..
Tenant (n)

Tenant (1)
..
..
..
Tenant (n)
UnitAdd1
UnitAdd2
UnitAdd3

Which is closer to what I want, but I am obviously still missing
something very basic.