combining items in secondary table

[jsrogol]

I "inherited"a database for an organization that came from excel. It now has
a primary table of people names and a secondary table with names of all
children for some of the people in primary table. I need to do a report that
will allow me to list ALL of the children's names on the same line. I can't
figure out how to do this.

The originial database has a field for each child in the primary table (6
fields) and I converted it to a secondary table. Actually it would be easier
to combine the data from the original design but I don't want to have all of
the "unused" fields.

Anyone have any suggestions?

Thanks

 

[Marshall Barton]

I "inherited"a database for an organization that came from excel. It now has
a primary table of people names and a secondary table with names of all
children for some of the people in primary table. I need to do a report that
will allow me to list ALL of the children's names on the same line. I can't
figure out how to do this.

The originial database has a field for each child in the primary table (6
fields) and I converted it to a secondary table. Actually it would be easier
to combine the data from the original design but I don't want to have all of
the "unused" fields.

If your child table has a separate record for each child,
you are definitely on the right track. The way to get all
the chilfren, even more than 6, is to use a function to
concatenate the child names.

Here's a good example of such a function:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16&SID=eee7fe9a9b7677c11a532b2de5b1ezb2

 

[KARL DEWEY]

If I understand correctly, you might want to try the generic concatenate
function at http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16.
Plagiarized from -- Duane Hookom Microsoft Access MVP