Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 17th, 2004, 11:46 PM
Registered User
 
Join Date: Nov 2004
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to vickr1z
Default find duplicate name on a table

good day to all..
i have a table with lot of duplicate names,
here's some of my data:

TABLE NAME: polmap

id lname fname position
1 Garcia Frank mayor
2 Merey Leslie deskman
3 Garcia Frank mayor
4 Abro Sid utility
5 Abro Sid utilityman
6 Hide Cleo clipman

how can i first find them and delete them with another SQL.


More Power!
 
Old November 18th, 2004, 08:29 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Use the Query Wizard to Find Duplicates, and the delete all but one from the results.

If there is more data to each record such that you must delete all but a specific record, then in the query wizard, make sure you include all the pertinent fields to allow you to determine which one is the right one to leave, and which ones you can safely delete.

I use this wizard a lot when I inherit a database and make a button on my administrative switchboard so that I can check the data for duplicates as I clean.

mmcdonal
 
Old November 18th, 2004, 08:30 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Sorry, that first line should be:

"...and THEN delete all but one from the results."


mmcdonal
 
Old March 22nd, 2005, 10:12 PM
Registered User
 
Join Date: Nov 2004
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to vickr1z
Default

i dont have Query Wizard to Find Duplicates in my Access. i just want to use sql statement

More Power!
 
Old March 23rd, 2005, 06:02 AM
Friend of Wrox
 
Join Date: Oct 2003
Posts: 168
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi

Yes you do have Query Wizard in your Access
Queries view you have New button and there is Find Duplicates Query Wizard

-vemaju






Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicate Records in a table i_shahid SQL Language 2 February 7th, 2008 07:40 PM
KickStart to Find and Delete True Duplicate Files asgarcymed VBScript 0 November 24th, 2007 11:10 PM
Delete duplicate entries from table expertcalling SQL Server 2000 2 January 2nd, 2005 11:51 PM
How to duplicate 1 row in table minhpx SQL Language 1 December 20th, 2004 09:51 AM
sql command to find duplicate records? qwjunk Classic ASP Databases 1 January 31st, 2004 03:32 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.