SELECT Count(NumbersField) AS CountOfField FROM table1 GROUP BY NumbersField
That does it, I tried it. Matt Small -----Original Message----- From: Hawkes, Keith A CIV [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 7:18 AM To: CF-Talk Subject: Count(*) Query I have a table that has one field that holds numbers 1 thru 9. Can I run a single query that will give me the count(*) of 1's, count(*) of 2's, etc. or do I have to run a separate query for each? Thanks to all, Keith ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
