Hi!
I propose a challenge to Access users out there!
In Access 2007 is it possible without using code to concatenate all the data from a single column?
For example imagine this column exists:
FirstNames
Jim
Jack
Sally
Fredrick
Alfi
I want to run a query that will combine all the first names into a list separated by some delimiter. The query should return a result in a single row and a single column like so:
DataResult
Jim~Jack~Sally~Fredrick~Alfi
Now, if this cannot be done without using code then provide a solution in code is fine as well, but please comment your code so I can understand what in goodness is going on!
If further clarification is needed please do not hesitate to post!
Please note this post is posted on multiple forums.
Thank you all! : )
Cordially,
Counterpoint