Create a single record from duplicate records

[VenusSaturn]

Hello,
I have an excel sheet with several duplicate values based on a member id field. I want to import this in access then create additional fields to hold the duplicate information. I've tried using Make Table query, append query..no luck yet. Is vba coding a better way? Thanks!

 

[pbaldy]

Are you sure, because in Access you would normally store data in records, not fields. Of course, I don't know the nature of the data. This is a good reference on design:

http://www.r937.com/Relational.html

If you stick with what you're doing, you'd probably run an append query to get the initial records, and then update queries to update the fields. Not knowing the nature of the data, it's hard to be specific.

 

[VenusSaturn]

Here is what I have currently in a table in access:
Member_Id Status Name Member ID_1 Member Name 1 Retiree Name 1 1 Spouse Name 1 98765 John Q Jones 2 Beneficiary Name 2 13579 David Main 2 QDRO Name 2 13579 David Main 3 Retiree Name 3 3 Spouse Name 3 24680 Denise Fish 4 Retiree Name 4 4 Spouse Name 4 48121 Kimberly Brown
There is more than 1 record for each Member ID. I want to copy the information from the second record and add it to the original record. The result would look like this:

Member_Id Status Name Member ID_1 Member Name Status_2 Member_Id_2 Member_Name_2 1 Retiree Name 1 Spouse 98765 John Q Jones 2 Beneficiary Name 2 13579 David Main QDRO 13579 David Main 3 Retiree Name 3 Spouse 24680 Denise Fish 4 Retiree Name 4 Spouse 48121 Kimberly Brown

Does this help explain what I want to do?

Thank you!