Create comma separated list from data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a database that includes a table of document names and other tables
of document characteristics. I also have many-to-many tables to link
documents and characteristics. I can create a form or report that shows
documents and their associated characteristics displayed vertically:
Document 1
Characteristic 1
Characteristic 3
Characteristic 9

However, I would like to create a comma separated list of characteristics in
a horizontal layout:
Document 1
Characteristic 1, Characteristic 3, Characteristic 9

I appreciate your help,

David
 
Hi.
However, I would like to create a comma separated list of characteristics in
a horizontal layout:
Document 1
Characteristic 1, Characteristic 3, Characteristic 9
Click to expand...

Please see the article, "Return a concatenated list of sub-record values" on
the following Web page for sample code:

http://www.mvps.org/access/modules/mdl0004.htm

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.
 
Back
Top