how to print mult. returns L-R instead of columns?

[Guest]

I have created several DB in Access, and on occasion, I have subforms that
may have mult records, thus the one to many relationship. When I create a
report, I want the report to read like a paragraph, with the mult records
separated by commas. an example would be a family who has three children. I
want: Silly, Sally, Sorry. What I always get, of course, is:
Silly
Sally
Sorry.
How do I get the access, or word to print L-R?

 

[Guest]

Try this KB article (works for more than just the Access 2000 indicated in
the title):

ACC2000: How to Concatenate Data from the 'Many' Side of a Relationship
http://support.microsoft.com/kb/210163

Here is another version as well:

Return a concatenated list of sub-record values
http://www.mvps.org/access/modules/mdl0004.htm


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Guest]

Thank-you. It was what I was looking for.

Try this KB article (works for more than just the Access 2000 indicated in
the title):

ACC2000: How to Concatenate Data from the 'Many' Side of a Relationship
http://support.microsoft.com/kb/210163

Here is another version as well:

Return a concatenated list of sub-record values
http://www.mvps.org/access/modules/mdl0004.htm


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Guest]

You're very welcome. Glad I could be of help.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________