Several records merged to one record

[Guest]

Hello,

I think I need to create a crosstab query and I would like to have your help
please. I have a student table with last name , first name and family field.
We have students that may have upto 4 students to one family. So that
means that I have upto four records per family. There are other fields in
the table but do not need them at this time. The family field is coded to
keep the family grouped together. Is there a way that I can create one
record per family instead of 4. The crosstab query was giving me totals. I
would like this to read:

Lastname Firstname Firstname Firstname Firstname

Keep in mind that some families can contain only 1, 2 or 3 students. The
number of students will vary per family.

Thanks for your help,

Robin

 

[Duane Hookom]

There is a generic Concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. Since
your question seems to involve a report, you could limit the main report to
family info and place the "child" info in a multiple column subreport.

 

[Guest]

Can you give me some hints on how to set up the report. That might be the
best way to go. I am not that familar with multiple column subreports

 

[Duane Hookom]

I replied in the Reports ng.