Print Page | Close Window

Generic Function To Concatenate Child Records

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Hookom, Duane
Forum Description: Duane Hookom's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16
Printed Date: 28 Mar 2024 at 8:19am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: Generic Function To Concatenate Child Records
Posted By: Duane Hookom
Subject: Generic Function To Concatenate Child Records
Date 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: http://www.rogersaccesslibrary.com/forum/uploads/4/Concat2k.zip - uploads/4/Concat2k.zip


-------------
--
Duane Hookom
Microsoft Access MVP
Eau Claire, WI



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net