bruce_bruen at mlc.com.au
bruce_bruen at mlc.com.au
Thu Jan 22 18:19:34 CST 2004
Check the archives, I had a similar problem last year. I believe it was
either Wiliam H or Gustav thtat provided the answer using a select first,
last or max field in the table you wish to delete from. You could search on
my surname.
Sorry, the actual anser is on a drive I dont have anymore....
Bruce
"Dave Sharpe"
<davesharpe2 at cox.net> To: "Access Developers discussion and problem solving"
Sent by: <accessd at databaseadvisors.com>
accessd-bounces at databasea cc:
dvisors.com Subject: Re: [AccessD] query that deletess dups ?
23/01/2004 11:14
Please respond to Access
Developers discussion and
problem solving
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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com