Generic Function To Concatenate Child Records

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   This file contains a concatenate function and samples of how to use it. The function creates a single, delimited list of the "many" records from a 1-to-many relationship. The delimiter defaults to a comma but can be specified. The function can be easily modified to use either DAO or ADO by commenting or un-commenting some lines of code.
A table with records like:
  ABC Co.      Bob
  ABC Co.      John
  ABC Co.      Sarah
  ABC Co.      Aaron
can be converted to:
  ABC Co.      Bob, John, Sarah, Aaron
or
  ABC Co.      Bob - John - Sarah - Aaron
Download Access 2000: uploads/4/Concat2k.zip

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Duane Hookom Members Profile Send Private Message Find Members Posts Add to Buddy List Microsoft MVP Joined: 20 Feb 2008 Location: Eau Claire, WI Status: Offline Points: 12	Post Options Post Reply Quote Duane Hookom Report Post Thanks(0) Quote Reply Topic: Generic Function To Concatenate Child Records Posted: 23 Jun 2008 at 11:03pm
	This file contains a concatenate function and samples of how to use it. The function creates a single, delimited list of the "many" records from a 1-to-many relationship. The delimiter defaults to a comma but can be specified. The function can be easily modified to use either DAO or ADO by commenting or un-commenting some lines of code. A table with records like: ABC Co. Bob ABC Co. John ABC Co. Sarah ABC Co. Aaron can be converted to: ABC Co. Bob, John, Sarah, Aaron or ABC Co. Bob - John - Sarah - Aaron Download Access 2000: uploads/4/Concat2k.zip
	-- Duane Hookom Microsoft Access MVP Eau Claire, WI

Sponsored Links