98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Deleting duplicates
Deleting duplicates
Resolved · Medium Priority · Version 2013
Tue 26 Apr 2016, 10:28Delegate Claire said...
Claire has attended:
Access Intermediate course
Deleting duplicates
Following on from the Intermediate course last week, I am trying to use the method that was used to remove duplicates - by selecting several fields that need to be unique as primary keys and then I would create an append query using a blank copy of my table structure alone. I am selecting several fields as the primary key but I am getting an error message saying that "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data..., remove the index or redefine the index to permit duplicate entries and try again." I have some test data which includes duplicates so I am trying to see if it will remove them but not being able to get that far.
Thanks,
Claire
Tue 26 Apr 2016, 12:41Trainer Doug said...
RE: Deleting duplicates
Hi Claire
I've just tried out the process of removing duplicates you and the trainer suggested. It gave a different warning but then removed the duplicates in the appended table.
Hard to tell why it didn't work on your test data. It might help if you send your example to info@stl-training.co.uk and ask to forward to Doug.
Another way to remove duplicate records from a table is to create a normal select query (rather than append query).
Add all the fields and set the query property Unique Values to Yes. (To see Query properties, right click, the background of a query and choose Properties).
The query could then be changed to a Make Table query to create the table of unique records.
It would be worth trying this to find out how many unique records there are.
Hope that helps?
Regards
Doug Dunn
Best STL
Fri 20 May 2016, 14:13Trainer Doug said...
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Fri 27 May 2016: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Change The Default Font in Access 2003You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set. |
