Forum home » Delegate support and help forum » Microsoft Access Training and help » Anthony: Duplicates
|
|
|
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. |
Anthony: Duplicates
Resolved · Low Priority · Version 2007
Reply Delegate Alain said...
Alain has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course
Introduction to Management course
Anthony: Duplicates
Hi Anthony,
Could you please send us a procedure that we could use to remove duplicates contained in a database?
I am not only interested in finding duplicates. I also would like to be able to remove the relevant records.
I thank you in advance for your help.
Alain
For upcoming training course dates see: Pricing & availability
RE: Anthony: Duplicates
Hi Alain, good to hear from you again. Here is Microsoft's advice on dealing with duplicates in your database:
http://office.microsoft.com/en-us/access-help/find-eliminate-or-hide-duplicate-records-in-access-HA001034558.aspx
...and here is a real-world example which shows you the sort of hoops you'll have to jump through:
http://dailycupoftech.com/2009/03/29/remove-duplicate-records-in-access/
Hope this helps,
Anthony
|