Unanswered: Accessv2003-Need to combine multiple contact records into a single record
Apologies if this has been answered adequately somewhere already. I didn't find it.
I work in a K-12 school district and handle the data management (am not a DBA). Each student usually has multiple "parent/guardian" contacts. When I export these out of the existing database (SASI - db4), I get a separate record for each of the contacts for a student. I can extract it to either comma or tab delimited and I can pull it into Access with no problem... but...
I need to get these multiple records combined into a single record for each student with the following information:
--Student name, etc
--PG1 Relationship (to student)
--PG1 Main Phone
--PG1 Secondary Phone
--PG2 Relationship (to student)
--PG2 Main Phone
--PG2 Secondary Phone
I have to get this accomplished for various reasons. I need to be able to pull it into a simple excel spreadsheet for others to use as well (comma/tab delimited - I don't care... either will work)
There are multiple reasons I need to accomplish this. We are also switching student management systems, going from SASI to PowerSchool. The new system is structured completely different, and has a single student record for each student with the multiple contact structure described above.
I have seen this question asked numerous times and have seen several replies on why it shouldn't be done, but none that explain how to do it for those of us that need to do it. I don't need more of that. I simply need an answer to how it CAN be done... Thanks much in advance for any help you can provide.
I would argue against storing data that way, but it's not uncommon to need it exported out as you've described. If it can be concatenated into a single field, this could be adapted to handle the multiple fields: