>No been following this thread, but can you do the first two parts? Yes, I've got this part working with Jochem's fine SQL.
> >What about the third part? > >"With each possible answer, show me a count of the ones that were selected" Nope > >Do those then try to combine them. > >Adrian This is where the problem is. I haven't figured out how to combine them, group them, whatever needs to be done, I haven't gotten it right yet. I can't quit on this until it works. Here's the data retrieval as it stands now: http://wtomlinson.com/evalQRYs/qryDatabig.gif Here's the data in my many table: http://wtomlinson.com/evalQRYs/tableData.gif This shouldn't be hard!! Thanks adrian, 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:273249 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
