removing duplicate records in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have made a "find duplicates" query using a table named patient_list2
the query returns the following feilds- last name, first name, DOB, id
i need to delete the rows that match exactly except for the id#'s
please be gentle with me as i am very green as far as database go.

jeff
 
So what rule do you intend to use to identify which records to keep? The one
with the lowest ID, the highest Id, a random one?

Is this a one time thing? Is ID your primary key field?

Post back with the SQL statement you used to get the duplicates. Switch to SQL
view (not design view) and then copy and paste the text to your message.

Perhaps someone can then answer you.
 
Back
Top