Combining fields from multiple records

O

otisg1

I am reposting this because the previously posted reply did not produce the
correct results .
..
I have a rental property database. There are 2 tables that I am concerned
with here:

(PROPERTY table)
PID
Street
City
State
ZIP
....

(TENANT table)
PID
FirstName
MI
LastName
.....

The tables are linked via PID (Primary Key) and there can be up to 4 Tenant
records per Property record. I would like to create a query that would
contain all the tenant names and the address information in one record so
that it can be used as the data source for Word mail merge documents. The
records returned from the query should look like:

Tenant
Tenant
Tenant
Tenant
Street
City
State
ZIP

Is this possible? If not, is there a better solution to this? Thanks in
advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining fields from multiple records 6
Adding records - automatic numbering with two primary keys 2
Auto Add new records on a specified date 0
Auto add a new record on specified date. 0
Fixed width text box in Word 2007 9
Controlling fields in continous subforms (hunting for ideas) 1
Query/Report Output Based on Current Record in a Form 3
Printing mailing labels with multiple recipient name records associated with a single address 5

Top