Field concatenation

[Guest]

Is there a way to concatenate fields in an Access query or report? For
example if all other data is the same except one field on multiple records,
can you combine the unique field to create one record like:

Jim likes to fish for trout.
Jim likes to fish for salmon.
Jim likes to fish for tuna.

Would like to display as: Jim likes to fish for trout, salmon, tuna.

 

[Guest]

Your sample data looks like all one field which you grab only the last word
to concatenate. If you can parse off the last word from the remainder of the
field value, you can use the generic concatenate function found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Guest]

Concatenating unique field values for records matching a query's GROUP BY
clause
http://www.accessdb.info/content/view/102/40/

Hope that helps!