[AccessD] query that deletess dups ?

How can I delete dup records ? Anyone can give me a hint...

SELECT DISTINCTROW [emp table].[employee number], [emp table].[employee
name], [emp table].COMPANY
FROM [emp table]
WHERE ((([emp table].[employee number]) In (SELECT [employee number] FROM
[emp table] As Tmp GROUP BY [employee number],[employee name] HAVING
Count(*)>1  And [employee name] = [emp table].[employee name])))
ORDER BY [emp table].[employee number], [emp table].[employee name];


-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail