Hi!

The same idea. 'Where' will filter out records for count() function.

Select IDField, count(IDField) as nCount
from MyTable
where MyDateField betwen m.ldDate - 10 AND m.ldDate + 10
group by IDField
having nCount>1


>>>I'm switching an index to a primary and am getting a duplicate index message. How can I find the duplicates amoung 1000's without
>>>looking through them all?
>>
>>Select IDField, count(IDField) as nCount
>> from MyTable
>> group by IDField
>> having nCount>1
>
>This question was asked so often, what it definitely should be in a FAQ.
>
>BTW, a little more complicated variation of this problem:
>Find all duplicates, which have the same Id field and date within date specified +-10.