Wow! Steve & Albert that was quick, thank you very much for the help.
Gary
--------------------------------------------------
From: "Steve Vellella" <[email protected]>
Sent: Friday, July 09, 2010 7:30 PM
To: "RBASE-L Mailing List" <[email protected]>
Subject: [RBASE-L] - Re: Selecting Grouped Records
Just to add to what Albert told you:
You can use the select statement in conjunction with the print command -
Print reptname where address in (SELECT Address, COUNT(*) From Table GROUP
BY Address HAVING COUNT(*) > 3)
Steve
Steve Vellella
Office: 520-498-2256
Cell: 520-250-6498
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Albert
Berry
Sent: Friday, July 09, 2010 7:17 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Selecting Grouped Records
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
