deleting duplicates

[Guest]

I have this table with a field called machine names

there are dupllicate values in this field.
However, I am trying to make it a unique value
I want just one instance of it so i want to delete the field if it has more
than one instance of that value

It does not matter which value is deleted, there is no critera
Do I have to manually go through the list and delete the duplicate instances?

Thanks for the help.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "RemoveDuplicates2k.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

thanks!

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "RemoveDuplicates2k.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L