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
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