Yes, using Steves example query as a foundation. I assumed you were using a relational model with separate questions/answer tables but that is not the case. You wont need joins or conversions. Steves "Sum(case response = 'agree' then 1 else 0 end) as agree query is what you are looking for.
Jon On Dec 10, 2014, at 9:39 PM, Torrent Girl <[email protected]> wrote: > > Jon can I do this even though "disagree", etc. are columns but actual values? > > >> I could be wrong, but it seems like you might be making it harder than >> it needs to be from the query side, if you are looking for totals of >> responses by question. You might be able to just use a GROUP BY >> clause to handle it. >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:359818 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
