Access 2007 Tutorial 5.3. Delete Duplicate Records

[malcorub]

I understood what we did in video 5.1 and 5.2 and I understand what the goal is in 5.3, I am just not understanding how we arrived at the solution and I have watched this 3 times.

We went from 72 records, then allowed duplication via properties and went to 342 records, then to 67, then back to 72. Let me watch this a 4th time.

Definitely NOT beginner video. Thank you so much for sharing your knowledge.

[pplala100]

SWEET VID

[RogueX20]

Can this only be done on Primary Key? I tried on a field that is not a primary key and the query never finishes. I see running query but the progress bar never shows up.

[djdates]

@RogueX20 I'm sorry, but I am not exactly sure what you are asking. We use the PK in the delete query because it gives a unique identifier for the record when we want to delete it. If you have another identifier that you are confident is unique, you could use that.

If you are having a problem with your query, try making it as simple as possible and then add complexity, so you can determine exactly when it starts to go wrong.