Concatenate child records with multiple fields

[Bob]

Hi,

so i've been reading on the concatenate child records and i can use it in a query where im looking at 2 columns and getting similar records on one line ex.

Team Name
Red Joe
Blue Mike
Yellow Bob
Red John
Red Allen

results
Red Joe, John, Allen
Blue Mike
Yellow Bob

thats using fConcatChild Function

But here is where i get in trouble:


what i have is

Team Name Project Season
Red Joe 1 1
Red Bob 1 1
Red Mike 1 1
Red Allen 2 1
Blue John 1 1
Blue Dan 2 1
Yellow David 1 1
Yellow Tony 1 1

so i need the names to be on the same line where Team, Project and Season are the same:

Team Name Project Season
Red Joe, Bob, Mike 1 1
Red Allen 2 1
Blue John 1 1
Blue Dan 2 1
Yellow David, Tony 1 1


If anyone has any examples or can suggest any help for creating access query that can do this please help lol

thanks