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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Use a "totals" query, with SQL statement similar to this:

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