Combine text from a field in multiple records

[Ron]

I have a database that tracks projects. Included in the tracking is a list of
the product(s) effected by the project. In a summary of a project I would
like to include the products effected as a single continuous text string
rather than a list column.

Example:
Project: 123 (project control number)
Date: 1/16/08 (start date)
Description: Change Color (Desc)
Products Effected: ABC, MNO, RST, XYZ (from a second table that relates back
to the first by the project control number field)

 

[Marshall Barton]

I have a database that tracks projects. Included in the tracking is a list of
the product(s) effected by the project. In a summary of a project I would
like to include the products effected as a single continuous text string
rather than a list column.

Example:
Project: 123 (project control number)
Date: 1/16/08 (start date)
Description: Change Color (Desc)
Products Effected: ABC, MNO, RST, XYZ (from a second table that relates back
to the first by the project control number field)

You need to create a function to do that. I like the one
at:
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'