Put every field from the select that is not an aggregate in your >group by and you get something understandable. > >Jochem
Jochem, I did this and it still gives me incorrect results. It gives me a count of 1 for each answer, no matter what the answer is. I'm just testing with one evaluation record to keep it simple. I should still get 0 records returned for some of these answers. I don't know why I can't simply run a query that says this: "Show me a list of all the questions. With each question, I need all possible answers. With each possible answer, show me a count of the ones that were selected" I should be able to get this with a query, but I'm not. I'm missing something. ARGHHHH!! Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273245 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
