Jumat, 15 April 2016

[MS_AccessPros] Re: Finding duplicates without a primary key

 

Karen

Sad to say there really isn't much you can do for misspellings. You'll probably have to check that manually. I find sorting on the field the most helpful way of spotting those things.

As far as duplicates go you can make a copy of the table (structure only) and in the copy select the fields that would constitute a unique row such as name and address. Set those as the primary key. Then append all the records in the original table into the copy. All duplicates will not go in due to primary key violations.

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.microsoft.com/en-us/PublicProfile/35852?fullName=Bill%20%20Mosca
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com

 

__._,_.___

Posted by: wrmosca@comcast.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar