Either way the count now seem to return the full number of results rather than the individual tallies?
i.e Doug's. | Question | Answer | Count | ----------------------------- | Red Fav | Yes | 7 | | Red Fav | No | 7 | | Red Fav | Maybe | 7 | |like pets | Dogs | 7 | or Chris's grouped version: | Question | Answer | Count | ----------------------------- | Red Fav | Yes | 7 | |like pets | Dogs | 7 | Uposed to the output I need: | Question | Answer | Count | ----------------------------- | Red Fav | Yes | 3 | | Red Fav | No | 2 | | Red Fav | Maybe | 1 | |like pets | Dogs | 1 | ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266982 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
