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!

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

Sorry, that first line should be:

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


mmcdonal

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

More Power!

Hi

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

-vemaju