[AccessD] query that deletess dups ?

Oleg ( I think )

As there have been no attempts yet; I googled and found the
following that looks like it should help You.

http://www.databasejournal.com/features/msaccess/article.php/3077791

Dave


----- Original Message ----- 
From: <Oleg_123 at xuppa.com>
To: <accessd at databaseadvisors.com>
Sent: Thursday, January 22, 2004 4:20 PM
Subject: [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


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com