Concatenate child records with multiple fields

Bob

Joined
Apr 4, 2012
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top