Same field Concatenation

[jpanalyst]

Hey guys could use some of your help,

I have a two tables containing similar information, which can be seen below. The table on the left has unique entries for peoples 'names', however two people can share the same 'GroupID' (for grouping reasons). I am looking to put a relationship between the 'GroupID' fields in both tables but I require some kind of concatenate field to merge all the people with a matching 'GroupID' into the one 'Names' field (in the right table).

e.g. The table on the right would end up with:
GroupID = 1
Names = Fred; Oliver

Thanks in advance for any advice you can give me,

Jack.

 

[Atomic Shrimp]

Your choice of the term 'ID' might confuse some people at some point in the future - you might be better off calling it what it is; 'group' (except that 'group' is a reserved word, so you would have to call it 'usergroup' or something appropriate).

It's not easy to concatenate a list of similar rows into a single cell (it is easier and more usual to just list them as details under a group heading in a report), but the question does come up from time to time - such as here:
http://www.access-programmers.co.uk/forums/showthread.php?t=173947

 

[jpanalyst]

Thanks Mike,

Appreciate the link and the advice.