combining items in secondary table

  • Thread starter Thread starter jsrogol
  • Start date Start date
J

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
 
jsrogol said:
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.
Click to expand...


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