delete extra records

  • Thread starter Thread starter Jim
  • Start date Start date
J

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.
 
-----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
Click to expand...
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
 
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.
Click to expand...

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...
 
Back
Top