You're right, I didn't see your query when I wrote this one. -----Original Message----- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 9:52 AM To: CF-Talk Subject: RE: Count(*) Query
> SELECT Count(NumbersField) AS CountOfField > FROM table1 > GROUP BY NumbersField > > That does it, I tried it. But you only get the Count, so you don't know what it's a count of... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
