Several records merged to one record

R

Robin

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
 
R

Robin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top