leezac
asked on
How to Concatenate many rows into one
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
Thanks In advance!
db8.zip
ASKER
What do you suggest?
ASKER
It is just going to be used for a report not anything else.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
"What do you suggest? "
Like I said, What do YOU NEED that info in a single field for?
Like I said, What do YOU NEED that info in a single field for?
ASKER
It is to show on a Report - that is all. I think IrogSinta may have given me a solution - I just need it applied.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.