Thanks to everyone who responded. I appreciate the wealth of knowledge that is out there on the list. Thanks again! rm
-----Original Message----- From: Gilbert Hach� [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 12:57 PM To: Morris, Rich Subject: RE: MI-L Count Question Use can use the following syntax that will give you the number of utilities by code sorted by occurance 9col2) >From Mapbasic windows copy-paste and modify this Or you can use the SQL Query Select Zip, Count(*) from utility_table group by Zip order by 2 into ZIP_group Browse * From zip_group Or you can use the SQL Query builder Select : Zip, Count(* >From : utility_table Where: blank! Group by column : zip Order by columns : 2 Into table name: yourchoice (by default selection) (Check browse result) You can save thequery as table, re-open your saved copy and make other quries on it like "where coloumns 2 is bigger then 1 to remove the unduplicate.. Good luck Gilbert -----Original Message----- From: Morris, Rich [mailto:[EMAIL PROTECTED] Sent: March 17, 2003 15:00 To: MI-L (E-mail) Subject: MI-L Count Question Listers, I would like to ask for some help. And it is probably a simple solution, but I can't seem to find it. I have a spreadsheet of utilities operating in certain Zip codes. So my table has the State, Zip, and Utility. I would like to find a quick way to see if there are more than one utility, according to this spreadsheet, operating in any given zip code. Or in different terms, I want a list of all zips with more than one utility. tia for your help. rm --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 6004
