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