Concatenating fields from matching records

[MWMike]

Hi guys,



I have a bill of materials problem I need some direction on. I have a query that yields a list of components used in an assembly. Each instance of a component has its own unique reference designator (see first attachment). Now, I want to create a new query from the existing one which groups / concatenates the reference designators together for matching part numbers (see second attachment).

Thanks for your help

[MWMike]

I see someone had almost the exact same question at: https://www.accessforums.net/program...ield-2226.html

I will try adapting the code provided. Any other suggestions in the meantime?