how do i filter for records that occurs mutiple times in access?

[Guest]

I have a database of over 100,000 records. I want to locate addresses of
accounts that occur multiple times (example, 6 times) within a specific
field. How do I do this? Thax 4 ur help

 

[Ken Snell [MVP]]

Use a "totals" query, with SQL statement similar to this:

SELECT AddressField
FROM TableName
WHERE Count([AddressField]) >= [Enter number:]
GROUP BY AddressField;