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 > >
