Ah! Thanks That did it.
Here is the final output http://2.bp.blogspot.com/-oKsNq87XFTA/VInEGGQsv1I/AAAAAAAADzE/wY-FE_hTcIg/s1600/finalOutput.png Thanks so much to all of you! > Since youre handling all of the the counts in the case statements, > you dont need to select the increasedKnowlege column value, order or > group by it anymore. Your SQL should be: > > SELECT > Sum(case increasedKnowledge WHEN 'agree' then 1 else 0 end) as 'agree', > > Sum(case increasedKnowledge WHEN 'disagree' then 1 else 0 end) as > 'disagree', > Sum(case increasedKnowledge WHEN 'Neither Agree nor Disagree' then 1 > else 0 end) as 'Neither Agree nor Disagree', > Sum(case increasedKnowledge WHEN 'strongly agree' then 1 else 0 end) > as 'strongly agree', > Sum(case increasedKnowledge WHEN 'Strongly Disagree' then 1 else 0 > end) as 'Strongly Disagree' > FROM evaluationReponsesCourse13 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:359831 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
