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 » Anthony: Duplicates
Anthony: Duplicates
Resolved · Low Priority · Version 2007
Wed 25 Jan 2012, 16:43Delegate 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
Fri 27 Jan 2012, 07:15Trainer Anthony said...
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
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:Prefixed AutonumberingWhen using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter. |
