i have a query that returns 2 columns. the first column has multiple instances of the child id, the second has related data. what i need to do is get a result that gives me one instance of the child id and combines the related data into one field seperated by a comma.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
combine results into text field
- Thread starter Senjen
- Start date
jimmythegeek
Programmer
Create a custom function that will return the related information in the form of a string, passing it the child id, and then put the child id in the first column, and call the function (make sure it's public) from the second column.
Done it many times, works fine. If you have any trouble, let us know. Jim Lunde
compugeeks@hotmail.com
Custom Application Development
Done it many times, works fine. If you have any trouble, let us know. Jim Lunde
compugeeks@hotmail.com
Custom Application Development
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Question
