Combine text from a field in multiple records

  • Thread starter Thread starter Ron
  • Start date Start date
R

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)
 
Ron said:
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)
Click to expand...


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