Hello all,
I have a query which provides a Project_ID and Name. I would like to take this query, and have it create insert into a temporary table, which then will add all of the names of the same Project_ID to a single cell (column/row) with the related project_id next to it.
My understanding is I will need to create a module which will contain a Loop, which adds the Name or related Project_ID to the temporary table. And if there are multiple Names associated with a Project_ID, the loop continues until < 1.
While I understand the concept of what needs to be done, the actual coding is the confusing part to me. Would anyone have any sample or example VBA coding that would help achieve this?
Much appreciated, thank you!
I have a query which provides a Project_ID and Name. I would like to take this query, and have it create insert into a temporary table, which then will add all of the names of the same Project_ID to a single cell (column/row) with the related project_id next to it.
My understanding is I will need to create a module which will contain a Loop, which adds the Name or related Project_ID to the temporary table. And if there are multiple Names associated with a Project_ID, the loop continues until < 1.
While I understand the concept of what needs to be done, the actual coding is the confusing part to me. Would anyone have any sample or example VBA coding that would help achieve this?
Much appreciated, thank you!
