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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicates in union query 3
remove duplicate records in Access 2007 7
Basic Select Query Duplicating a single end user's records 2
Combine Duplicates in Query 0
deleting duplicate records obtained from a duplicate query 4
Query that will look for duplicate in two tables. 3
Remove duplicate records 1
Queries without duplicates 5

Back
Top