combine fields from many records based on a key field

[cwitczak]

I have many records that have a field in common (SBL) but different owners
names. I would like to have one record with SBL and all the owners names
listed.

 

[BruceM]

If I understand you correctly a query should do what you need. In the query
design grid, click in the Criteria row underneath SBL, and add the criteria.
For instance, if the records you want have the value "Yes" in SBL, make "Yes"
the criterium by typing the word in the Criteria row under SBL. This query
can be used as the basis for a form (for viewing and working with the data on
screen) or a report (for printing).

 

[cwitczak]

The table looks like this

swis print_key owner_first_name owner_last_name owner_type
331300 6-7-16 Ronald Van Aken P
331300 6-7-16 Charlotte Van Aken - Lambert A
331300 9-1-18 David Van Benschoten P
331300 9-1-18 Diana Van Benschoten A

I would like to combine the records where print_key equals the next print
key. There could be several owners to a print_key. The first record is the
primary owner(Owner_Type = P) but a print_key could have many Additional
Owners.

 

[Duane Hookom]

There is no such thing as next and previous in Access records without some
value(s) that identify a sort order.

You supplied what you have but not what you mean by "combine the records".

 

[cwitczak]

331300 9-1-18 David Van Benschoten P
331300 9-1-18 Diana Van Benschoten A

With the above example, I would like to combine the 2 records above. And
make it appear:
Owners Field Owner Type
331300 9-1-8 David Van Benschoten P
Diana Van Benschoten A

This way on the form it would display 1 record with the 2 owners.

 

[Duane Hookom]

You can hide duplicates in a report but not in a form.