[AccessD] Duplicates Query

Rocky Smolin rockysmolin at bchacc.com
Wed Sep 1 10:38:33 CDT 2010


 Gustav:

Looks right but it has step 2 as:

2. Create a totals Query1 which shows GroupBy the name, and First of the PK.

I assume totals query = summation query.  But "GroupBy the name" - what does
'name' refer to?  And how to do First of the PK?

TIA

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Wednesday, September 01, 2010 12:16 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Duplicates Query

Hi Rocky

Yes. Look up a not so old thread:
http://databaseadvisors.com/pipermail/accessd/2009-May/068576.html 

/gustav


>>> rockysmolin at bchacc.com 31-08-2010 18:42 >>>
Dear List:

I used the find duplicates query wizard to make a query to find duplicate
records in a table.  Is there a quick way to then delete all but one
occurrence of the duplicated records?

MTIA

 

Rocky Smolin

Beach Access Software

858-259-4334


--
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