Rocky Smolin
rockysmolin at bchacc.com
Wed Sep 1 11:56:45 CDT 2010
Gustav: There are actually three fields that have to match up to make a duplicate. I suppose I could add another field which is the concatenation of those three but that seems kludgey. Any other more elegant solution? 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 8:49 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Duplicates Query Hi Rocky Use First or Last or Max or Min - just one that will return only one PK of the records where the field named "name" holds identical values. /gustav >>> rockysmolin at bchacc.com 01-09-2010 17:38 >>> 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