Hello Ahmed, I'm sorry I don't follow. Is this done under "Select" or "SQL Select"?
Thanks, Frank Select TYPE,count(*) from Onair group by TYPE into Selection Regards, Ahmed -----Original Message----- From: Brancato, Frank [mailto:brancatf@;tycoelectronics.com] Sent: Tuesday, October 22, 2002 4:18 PM To: '[EMAIL PROTECTED]' Subject: MI-L Record Count Hello, Does anyone know how I can extract a record count into a new table? I have a table with millions of points and associated labels. I would like to Sum all the common labels and view the record count just like the Legend "Show Record Count" option. Thanks in advance, Frank B. ******* Important Confidentiality: This communication is intended for the above named person and is confidential and/or legally privileged any opinion expressed in this communication are not necessarily those of the Egyptian company for Mobile Services (MobiNiL). If it has come to you in error you must take no action based on it, nor must you copy or show it to anyone: please delete/destroy and inform the sender immediately. No Responsibility: MobiNiL is not responsible for any political, religious, racial or partisan opinion in any correspondence conducted by its domain users. Therefore, any such opinion expressed, whether explicitly or implicitly, in any said correspondence is not to be interpreted as that of MobiNiL. Monitoring / Viruses: MobiNiL may monitor all incoming & outgoing e-mails in line with current legislation. Although we have taken steps to ensure that this e-mail and attachments are free from any Virus, we advise that in keeping with good computing practice the recepient should ensure they are actuallyvirus free. The Egyptian Company for Mobile Services (MobiNiL) www.mobinil.com <http://www.mobinil.com> The World Trade Center: 1191 Corniche El Nil, Boulaq - Cairo - Egypt Telephone: +20 2 574 - 7000 or + 20 12 320 - 0000 Fax: +20 2 574 - 7111 or +20 12 320- 7111 ******* --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3693
