combining fields that meet a criteria.

[jgonick]

I have two tables linked together by the "Key" field The first table is family information. (Last Name, address, etc..) The second table is individuals in the family. (Firstnames, birthdays etc..)

On a form and a report, I need to combine all the individual first names in one field. (nameone, nametwo, namethree)

What would be the easiest way?

Thanks

 

[RoyVidar]

Check out dhokoms faq faq701-4233.

Roy-Vidar

 

[jgonick]

This works great, Thanks.

Now I need it to list only the kids names. There is a number assigned to each kid. The number is always >2. (1&2 are the parents, 3 and on are kids) The field name is "familyposition"

How can I work it into the part below. I suppose I can use "And" but I'n not sure how to work it in.


Concatenate("SELECT FirstName FROM tblFamMem
WHERE FamID =" & [FamID])

Thanks for all the help.

 

[jgonick]

I figured it out. I just went to a query instead of the table.


Thanks for the help.