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
Last Comment
ASKER
What do you suggest?
ASKER
It is just going to be used for a report not anything else.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
"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
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
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.