Solved

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

Posted on 2014-11-03
2
98 Views
Last Modified: 2014-11-11
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
Comment
Question by:dhemple
2 Comments
 
LVL 45

Accepted Solution

by:
aikimark earned 500 total points
ID: 40419685
Use the DConcat() function described in Patrick Matthews' article.
http:A_2380-Domain-Aggregate-for-Concatenating-Values-by-Group-in-Microsoft-Access.html
0
 

Author Closing Comment

by:dhemple
ID: 40434830
Perfect solution.  thank you for pointing me in the right direction.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question