Duplicate Accounts

[mosh]

Hey all,

I have a table with account numbers, but need to find duplicate matches only, can't get it going.

AccountRef

Total: Group By
Criteria HAVING COUNT AccountRef >1

Thanks.
________
DEPAKOTE LAWSUIT INFORMATION

 

[cuttsy]

Have you tried the find duplicates query wizzard?