ACC2000: How to Combine Multiple Child Records into One Record (322813)
The information in this article applies to:
This article was previously published under Q322813 Advanced: Requires expert coding, interoperability, and multiuser skills.
For a Microsoft Microsoft Access 2002 version of this article, see 318642.
For a Microsoft Microsoft Access 97 version of this article, see 322863.
SUMMARY
This article shows you how to combine multiple child records into one
record.
In the following example, which uses the Northwind.mdb sample database, the SQL query passes the category name to the CombineChildRecords function. The function creates a category-specific Recordset object that is based on the Products table, and then parses the Recordset object to generate a comma-delimited list of products.
Modification Type: | Major | Last Reviewed: | 6/25/2004 |
---|
Keywords: | kbhowto KB322813 |
---|
|