[AccessD] Duplicates Query

Gustav Brock Gustav at cactus.dk
Wed Sep 1 12:09:15 CDT 2010


Hi Rocky

I believe you will have to group by these fields in a way to build a unique string, say:

  Group By [Field1] & "-" & [Field2] & "-" & [Field3]

/gustav


>>> rockysmolin at bchacc.com 01-09-2010 18:56 >>>
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






More information about the AccessD mailing list