GROUP BY and Concatenate?

**SIMMS7400** · 03-12-2021, 03:04 AM

Hi Folks -

I have the following structure:

PFC-11111	Chicken
PFC-11111	Steak
PFC-11111	Pork

I want to return PFC-111 Chicken, Steak, Pork.

Is that possible using MS Access sql query?

**Welshgasman** · 03-12-2021, 03:53 AM

Start by looking at Similar Threads at the bottom of the thread.
Google Allen Browne Concatenate

theDBGuy also has a similar function called SimpleCSV I believe.?

**alansidman** · 03-12-2021, 07:27 PM

I would do this in Power Pivot. See the link for tutorial on how to do this.

https://sfmagazine.com/post-entry/ju...a-pivot-table/

**Welshgasman** · 03-13-2021, 03:39 AM

Originally Posted by alansidman

I would do this in Power Pivot. See the link for tutorial on how to do this.

https://sfmagazine.com/post-entry/ju...a-pivot-table/

That is Excel though.?

I thought the O/P was wanting a method in Access.?

**alansidman** · 03-13-2021, 07:27 AM

True, he was asking about an Access Solution. I was offering up my opinion of how I would solve if it were my issue.

Man's mind stretched to new dimensions never returns to its original form.

**Micron** · 03-13-2021, 10:38 AM

maybe not as elegant but perhaps
https://stackoverflow.com/questions/...hrough-a-query

in which the accepted solution points to

https://stackoverflow.com/questions/...174843#5174843

**SIMMS7400** · 03-14-2021, 03:49 AM

Thank you, Micron!! I will take look!

GROUP BY and Concatenate?

Thread Tools

GROUP BY and Concatenate?

Similar Threads

Is there to paste a group of addresses into a group of hyperlink Access Cells?

group fields, count totals, and display group name and value of 0 if there are no records

SQL Query - Most recent date in a group - Select another field from the group

Page header showing when the data has ended, after a group but before the next group

Concatenate Field or Group by in Report or or or?

Posting Permissions