Merge Records

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?

See:
People in households and companies - Modelling human relationships
at:
http://allenbrowne.com/AppHuman.html

The article describes one very flexible approach to this, with a sample
database to show how the relationships work.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"CCloud" wrote in message
...
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?

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?

"Allen Browne" wrote:

See:
People in households and companies - Modelling human relationships
at:
http://allenbrowne.com/AppHuman.html

The article describes one very flexible approach to this, with a sample
database to show how the relationships work.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"CCloud" wrote in message
...
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?

Did you download the sample database?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"CCloud" wrote in message
...
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?

"Allen Browne" wrote:

See:
People in households and companies - Modelling human relationships
at:
http://allenbrowne.com/AppHuman.html

The article describes one very flexible approach to this, with a sample
database to show how the relationships work.

"CCloud" wrote in message
...
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?