Hi. I'm trying to concatenate records from different fields in a query, and found this old database by Duane Hookom, which I've adapted slightly. However, I'm trying to get it to nest the concatenated results. e.g. in queNames I'm trying to get Christina (Associate, Neighbor, Partner), rather than listed separately, but can't work out how to do that. Is there a straightforward way to do it?
Thanks!
Thanks!