I have a table with multiple records in it. I have a find duplicates query to find the duplicate records. The duplicate query counts the instances, but I need a way to bring up each individual record. I have another query with both the original table and the duplicates query in it with a relationship in order to pull the individual duplicated records. However it won't let me either update the record or delete the record. This can't be that difficult but I haven't written much in Access lately and my skills are a bit rusty. Any help/advice would be greatly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
I have a table with multiple record
- Thread starter Titusman
- Start date
A find duplicates query typically won't allow edits. You might be able to accomplish something similar using DCount(). If you need more information, please provide information about your table as well as the SQL view of your find duplicates query.
Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
- Thread starter
- #3
Thank you for your reply. I have solved it by creating a temp table with the results from the find duplicate query, changing that query into an append for that table and changing out the find duplicate query for the temp table inside my query that shows each record. Now I can delete the record from the main table with no problem.
Sounds like a lot of work but if it works for you then go for it.
Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
- Status
Similar threads
- Locked
- Question
- Locked
- Question
