Simple Concatenation Query
- or -
Post a project like this2472
$32
- Posted:
- Proposals: 8
- Remote
- #1626178
- PRE-FUNDED
- Awarded
Description
Experience Level: Intermediate
I want a simple query, built in Access97, that will take a simple two column table of data and group by the first Column (Cust#), and concatenate all the data in the second column (Conc) separated by commas.
Example:
Table Name Concat1
Column 1 Name=Cust#
Column 2 Name=Conc
Cust# Conc
01562O SO#18515-10/1/2017
01752W SO#16980-8/10/2017
01752W SO#16981-10/1/2017
01752W SO#16982-10/30/2017
01778R SO#18483-9/28/2017
01778R SO#18484-10/25/2017
Result:
01562O SO#18515-10/1/2017
01752W SO#16980-8/10/2017,SO#16981-10/1/2017,SO#16982-10/30/2017
01778R SO#18483-9/28/2017,SO#18484-10/25/2017
Example:
Table Name Concat1
Column 1 Name=Cust#
Column 2 Name=Conc
Cust# Conc
01562O SO#18515-10/1/2017
01752W SO#16980-8/10/2017
01752W SO#16981-10/1/2017
01752W SO#16982-10/30/2017
01778R SO#18483-9/28/2017
01778R SO#18484-10/25/2017
Result:
01562O SO#18515-10/1/2017
01752W SO#16980-8/10/2017,SO#16981-10/1/2017,SO#16982-10/30/2017
01778R SO#18483-9/28/2017,SO#18484-10/25/2017
David D.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
5 Jul 2017
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi David,
I have sent you solution using a query without VBA with complete instructions.
Thanks,
Farrukh Rehman
451020
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies