[AccessD] query that deletess dups ?

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





More information about the AccessD mailing list