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!