Crosstab Query in Access 97

[Guest]

I am trying to create a Crosstab Query but I can't get all of the records I
need to display. I need the data to be in a table format, with job titles on
the left (vertically) and team assignments across the top. At the
intersection of row & column I need the names of the individuals. I get all
of that, except in the positions where there are more than 1 person in a
position, on the same team. It will either show the first person (min) or
the last person (max), not all of the people.

What can I do?

Thanks for any help!

Cindy

 

[Duane Hookom]

You can Concatenate the individuals together using the generic function
found at http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.