How to Concatenate many rows into one

leezac
leezac used Ask the Experts™
on
In the attached sample database, I have a column Record Type where I need to be able to Concatenate the rows below into one row with commas seperating.

Thanks In advance!
db8.zip
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Neil RussellTechnical Development Lead

Commented:
WHY?

What you are suguesting breaks all the rules of database design...

What would you NEED a single field to contain multiple entities seperated by a comma? It is very very bad practice.

Author

Commented:
What do you suggest?

Author

Commented:
It is just going to be used for a report not anything else.
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

I remember something this on another post, I'm wondering if Duane Hookum's Concatenate function would work for  you.

http://www.rogersaccesslibrary.com/forum/topic16.html
or
http://www.tek-tips.com/faqs.cfm?fid=4233
Neil RussellTechnical Development Lead

Commented:
"What do you suggest? "

Like I said, What do YOU NEED that info in a single field for?

Author

Commented:
It is to show on a Report - that is all.  I think IrogSinta may have given me a solution - I just need it applied.
I personally like the function MakeCSV().

I have implemented it in the attached db.  See the Query object sel_ConcatenateRecordTypes.
db8.zip
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012
Commented:

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial