I have a table [tblWritersGroups] within which are four columns of names: [GroupLeaderName], [AltGrpLeaderName1], [AltGrpLeaderName2] and [AltGrpLeaderName3].
I want to concatenate the names into one column with commas separating more than one name. A simple &", "& displays all three commas regardless of whether or not the three extra rows have names in them. How do I write a single query expression that will not display extra commas in rows with less than four names?
Thanks in advance for any help............