Nigel,
>Try this (you will probably need to modify it for your own use).
>
>SELECT *, [keyinfo], count(*) as nTotal FROM yourtable GROUP BY [keyinfo] HAVING nTotal>1
>The HAVING may need to use count(*) instead of nTotal (I can't remember) but this will give you a list of duplicate entries.
This approach allows us only identify, that the records with this address are duplicate. It doesn't give us all dupes...
I tried Inner JOIN, but had an Error: "Not enough memory to complete operation..." :(
>>Hi everybody,
>>
>> I have a problem, which seems to me quite complicated. I need to find possible dupes in my table by address information and the date (date of transaction) should be in the particular range od days, say, within one week.
>>
>> As I can judge, it could not be done in one query...
>>
>> Could you please advise me more efficient way to find these possible dupes?
>>
>> The number of dupes may vary (in most cases, 2, but could be 3,4 or more).
>>
>> Thanks in advance.
If it's not broken, fix it until it is.
My Blog