Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 104
  • Last Modified:

Access code to Loop through stacked table and consolidate into another flatened table

Hello Experts.

I'm needing code that will loop through a stacked table and compile results into flat table that has one line for each ID

Example:

Table: StackedResults
ID     Name
1      Tom
1      Jane
1      Sue
2      Jane
2      Denise
3      Sue
3      Denise
3      Tom

Table: FlatResults
ID     Names
1       Tom, Jane, Sue
2        Jane, Denise
3       Denise, Sue, Tom

Thank you.
0
dhemple
Asked:
dhemple
1 Solution
 
aikimarkCommented:
Use the DConcat() function described in Patrick Matthews' article.
http:A_2380-Domain-Aggregate-for-Concatenating-Values-by-Group-in-Microsoft-Access.html
0
 
dhempleAuthor Commented:
Perfect solution.  thank you for pointing me in the right direction.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now