Merge Duplicate Information in 1 Table

[mshefferVT]

How would I merge information from duplicate records in one table?

THanks in advance!

-Matt

 

[fredk]

Hi Matt - Can you give me a little more information? Are you trying to take one table and make another table that does not have duplicates? If that is the case, you can copy and paste the table - When you paste, select "structure only" - Then in the new table, set the primary key to the field that you don't want duplicates on.

After then you can run an append query to move the data from your old table to the new table and it will not import the dups.

Let me know if that is not what you are trying to do or if you need more info.

Fred