how to erase duplicate rows - query help

[E_Gold]

hi

i have this table MEN

Name

____

aaa

bbb

nnn

aaa

aaa

nnn

i need to erase all duplicate rows (but leave only the first)

Name
____
aaa

bbb

nnn

i need any query that do it

 

[jdraw]

This is how others have attempted to remove duplicate rows.

http://lmgtfy.com/?q=ms+access+remove+duplicate+rows