Jumat, 15 April 2016

[MS_AccessPros] Re: Finding duplicates without a primary key



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.

Bill Mosca, Founder - MS_Access_Professionals
Microsoft Office Access MVP
My nothing-to-do-with-Access blog



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:

Posting Komentar