2 or more text values related to the same text value

[Debbie S.]

I have a database in which 2 or more text values (names) from one table may
be related to the same singluar text value from another table (a title). When
I query by title to find the names associated with that title, if there is
more than one name associated with that title it returns two rows of results,
with the same exact details except for the two names. Is there a way to
design a report such that if 2 names will be returned given one title, to
show only one set of results with both names together? I hope this question
makes sense.

Thank you,
Debbie

 

[Larry Linson]

I have a database in which 2 or more text values (names) from one table may
be related to the same singluar text value from another table (a title).
When
I query by title to find the names associated with that title, if there is
more than one name associated with that title it returns two rows of
results,
with the same exact details except for the two names. Is there a way to
design a report such that if 2 names will be returned given one title, to
show only one set of results with both names together? I hope this
question
makes sense.

I'm not sure I fully understand what you want, but Grouping on Title seems
appropriate:

Chairman
Carlos Gonzales
Board Member
Barbara Wilson
Mary Chu
President
Samantha Samuels
Vice-President
Phil Morris
Maurie Sanders
Chris Anderson

If you want it shown some other way, it is likely possible, but also likely
more work.

Larry Linson
Microsoft Office Access MVP