I've created a cross tab query using the query wizard. There are two row headings. Center and Team Description. As far as the headings they relate to different teams. Team 1, Team 2, etc. Now the field used calculated for each row column intersection is Person. I was wondering if there is a was to create a function to display all of the persons on the particular team for that center and team description. I was thinking about trying to do something along the lines of name1, name 2, etc. but all I can get the query to do is output the first or last name. I'm familiar with access but haven't dived into much SQL code at all. I've looked all over this forum and internet and have had no luck. Really would appreciate some help thank you!