Hello - I have to concatenate contact names associated with given client accounts for use in a mail merge routine. Is there a way to do this using only queries?
This is in an Access 2003 mde, for which I do not have the mdb (don't judge me!), so I can't add new VBA routines...
So, for an AcctNumber of "1", with 3 contacts, I can pull ContName by AcctNumber, and get:
1 Alex Adams
1 Bob Barker
1 Clyde Carter
Is there a way I can get to:
1 Alex Adams, Bob Barker, Clyde Carter
using only queries?
If I could just add a running counter to the 1st pull above, I could come off of that with a cross-tab query, forced to a fixed set of columns, and then just concatenate the names in the columns in a 3rd query. But I don't know how to generate a running counter in a query without using VBA.
So, any help with either of these problems would be very much appreciated