Generic Function To Concatenate Child Records |
Post Reply |
Author | |
Duane Hookom
Microsoft MVP Joined: 20 Feb 2008 Location: Eau Claire, WI Status: Offline Points: 12 |
Post Options
Thanks(0)
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: Download Access 2000: uploads/4/Concat2k.zip
|
|
--
Duane Hookom Microsoft Access MVP Eau Claire, WI |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |