Yes, the query would go something like this: Select WARD_NO, TENURE_TYPE, Count(TENTURE_TYPE) "How_Many" >From MY_TABLE GROUP BY WARD_NO, TENURE_TYPE ORDER BY WARD_NO, TENURE_TYPE Into RESULTS_TABLE
If you are using the SQL select dialog, the first line above is the 'Select Columns', the second line is the 'from Tables', the third line is the 'Group by Columns', and the fourth line is the 'Order by Columns'. Steve Kalmbach Systems Department The Grand Rapids Press 616-222-5498 [EMAIL PROTECTED] >>> "Andrew Tracey" <[EMAIL PROTECTED]> 01/14/2004 11:50:06 AM >>> Dear All I have a MapInfo table which comprises ward reference no and tenure type. I am trying to produce a query that will list the 20 wards and a count of how many of each tenure type there are in each ward. I want one browser with all results on. Is this possible. Thanks in advance Andrew Tracey Information Support Officer Corporate Information Corporate Growth and Focus Corporate Development South Tyneside Council Westoe Road South Shields NE33 2RL Tel: 0191 4247561 E-Mail : [EMAIL PROTECTED] ************************************************************************************************ Please do not print this e-mail if you can help it - and help protect the environment. ************************************************************************************************ This Message may contain confidential information and is protected by copyright. If you receive it in error please notify us and delete it without making use of or copying it. The addressee and other employees within the Council may read and copy any e-mail reply to this message and other e-mails you send to us. Whilst we use virus checking procedures we accept no liability for viruses and recipients must rely on their own virus checking procedures. ************************************************************************************************ The Council's web site address is www.southtyneside.info --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9883
