delete extra records

[Jim]

Hello,

I have this table fields: FirstName LastName Address

I need to check if there are more than one row where
FirstName and LastName are the same. I do not care if the
address id the same or not. I need to delete them until
there is only one left. What is the easiest way to do this?
Thanks,
Jim.

 

[Larry]

-----Original Message-----
Hello,

I have this table fields: FirstName LastName Address

I need to check if there are more than one row where
FirstName and LastName are the same. I do not care if the
address id the same or not. I need to delete them until
there is only one left. What is the easiest way to do this?
Thanks,
Jim.

.
Create a new table with the same fields and make the

firstname lastname primary keys.
create a query from the old table to append to the new
table. The append will only add one of each record

 

[John Vinson]

Hello,

I have this table fields: FirstName LastName Address

I need to check if there are more than one row where
FirstName and LastName are the same. I do not care if the
address id the same or not. I need to delete them until
there is only one left. What is the easiest way to do this?
Thanks,
Jim.

umm... you'll discard real people. Are you assuming that if there are
three people named Jim Smith in the table, that you can discard two of
them? I know three people named Fred Brown, and two named Lawrence
David Wise...