You need to do a group by on the address column, assuming they are all
formated the same.
SELECT Address, COUNT(*) From Table GROUP BY Address HAVING COUNT(*) > 3
You need a good index on the Address or this will dog a bit.
Albert
Gary Randall wrote:
Hello Everyone,
I have a table with data that came from the state Auditor’s office
it’s a list of voters. I have created a report that breaks on the
(Address) column, so if there are multiple voters living at that
address all the voters name will display under that address.
Now here is my problem: How do I print only addresses that have more
than 4 voters living there?
Thanks
Gary Randall
