Concatenate Field for Report/Query

[Reb]

I have a table with just Authors that has a relationship to the Title
table. In most instances there is more than one author per title.

When running a query/report that lists "Title -- Author" I get:

Book 1 -- John Smith
Book 1 -- Jane Doe
Book 1 -- John Gray
Book 2 -- Mary Poppins
Book 2 -- Dick White

I would like the report to say:

Book 1 -- John Smith, Jane Doe, John Gray
Book 2 -- Mary Poppins, Dick White

Can you concatenate only one field like the Author field? If so how do
you do it, what's the code, and do you put the code in the query or in
the report?

 

[Douglas J. Steele]

See whether http://www.mvps.org/access/modules/mdl0004.htm at "The Access
Web" helps. (There's also http://www.mvps.org/access/modules/mdl0008.htm
While that's for a slightly different scenario, it may make more sense to
you)

 

[Guest]

Hey Reb:

Actually, what you are doing is not concatenating - concatenating is
combining the data in different fields to create a new field. In your
example, what you are showing is that you would simply like the data
displayed in the Author field to be displayed differently.

You can do this by using Sorting and Grouping in your report. Try Grouping
by Book - that should give you a report that shows the Book Title with the
subsequent authors listed after:

Book 1:
John Smith
Jane Doe
John Gray

Book 2
Mary Poppins
Dick White

Hope this helps,

-TSC-