Merge Records

C

CCloud

I have a database with student names, student id numbers, parent names, a
family number and email addresses.
Every student in the school is listed multiple times because they have the
multiple parents.
I want each student listed only one time.
Also, I want each family listed only one time.
So, for a family it would have their family number, last name, each
students' first name, each parents' first name and all the email addresses
associated with the family.
Where do I begin?
 
C

CCloud

Allen, I think I see the point there, but my problem is the way my data was
entered, it is all in one table.
I am not sure if you are suggesting I need to separate it all into many
tables?
 
Top