Split a table into related tables

[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

[RickM]

You can create a make a table query and use the name field.
Group the name field to min or max. That should give you the list or table of the unique names only.