Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Hookom, Duane
  New Posts New Posts RSS Feed - Generic Function To Concatenate Child Records
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Please consider donating $1 per sample downloaded, (find out why here)

Generic Function To Concatenate Child Records

 Post Reply Post Reply
Message Reverse Sort Order
Duane Hookom View Drop Down
Microsoft MVP
Microsoft MVP

Joined: 20 Feb 2008
Location: Eau Claire, WI
Status: Offline
Points: 12
Post Options Post Options   Thanks (0) Thanks(0)   Quote Duane Hookom Quote  Post ReplyReply Direct Link To This Post 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
  ABC Co.      Bob - John - Sarah - Aaron

Download Access 2000: uploads/4/
Duane Hookom
Microsoft Access MVP
Eau Claire, WI
Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.