MySQL 5 Here's some table date as it looks in tblEvalAnswerResults. This is a many table.
http://wtomlinson.com/evalQRYs/tableData.gif Then here's what my query produces. I had to add E.evalID to get both evaluations to show up in the results. I went ahead and did another evaluation, so there are two tblEvaluations records, 3 questions each, which produced 6 records in the tblEvalAnswerResults many table. http://wtomlinson.com/evalQRYs/qryDatabig.gif How I should fix this query to give me what I need, I have no idea. I simply want to display each question, along with its possible answers, and a count of the answers that were chosen. All in the same query output in rows, like me link from the first post. Thanks, hope this makes sense. Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273232 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
