If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
skipped mail merge records | cls | Mailmerge | 1 | April 28th, 2005 05:54 PM |
How can I print the records I have entered in my mail merge datab. | TeresaL | Mailmerge | 1 | December 29th, 2004 09:13 PM |
Merge data from Excel into different docs in one Word file | sue_w1231 | Mailmerge | 1 | November 16th, 2004 12:55 AM |
Restrict records that match date criteria at merge time | Peter Wilde | Mailmerge | 1 | May 5th, 2004 08:40 AM |
Word 2003 is adding duplicate records to my mail merge | Doug Robbins - Word MVP | Mailmerge | 0 | April 24th, 2004 03:58 AM |