I'm not very experienced at this, but I need to create a report that creates a matrix (the number of times where, say, column f intersects the row 5).
I see how I can work the query (a kind of Where F AND 5 statement--other approaches appreciated). But I'm at a loss about how to output it so that it counts the total number instead of lists each incident. Is it done in the query or in the output? Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
