T
triley01
Hello,
I have imported a list from Excel with 25K records. Each row has Name
information (FN,LN,Co,Address,) plus Payment information (TransDate, Amount,
GL) If a person paid more than once their Name information is repeated with
the new Payment information. So the list contains many duplicate name entries.
From this table I would like to create a Name table that stores each unique
person only once and links to a Payments table which shows one or more
payments that each Name record has given.
How in Access can I accomplish this? Thanks so much for your help. Tim
I have imported a list from Excel with 25K records. Each row has Name
information (FN,LN,Co,Address,) plus Payment information (TransDate, Amount,
GL) If a person paid more than once their Name information is repeated with
the new Payment information. So the list contains many duplicate name entries.
From this table I would like to create a Name table that stores each unique
person only once and links to a Payments table which shows one or more
payments that each Name record has given.
How in Access can I accomplish this? Thanks so much for your help. Tim