Rick, > I'm working with a body of monthly 500 reports from which I need to distill certain information. > For the report output (which will take the form of a matrix), assume column f is Brown_Eyes > and assume row 5 is Big_Feet. > > I can easily imagine a query of the DB WHERE brown-eyes AND big_feet returns a list of 25 > of the 500 db records. But what I want to do is ouput the COUNT, not a list of db records. >
You need to be reading up on the GROUP BY clause and the COUNT() function. SELECT count(tblColumn) as resultcount FROM tblTable GROUP BY tblColumn Its not going to be right, but it gives you an idea of what you need to be reading up on and what you need to be doing with your query. Hope that helps Regards Stephen ============================ CF-Europe http://www.cf-europe.org/ Olymia Conference Centre, London 29-30 May 2003 Keynote by Ben Forta and Tim Buntel ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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