Unfortunately, this is a serious case of 'it depends' Can you describe how you want the data output to look?
Are you going to list every test and the test taker's scores on one view, or just one test taker per view, or just one question per view, or all test takers answers to one question per view? How is this app/report going to use the data? William ---------------------------------- William Seiter ColdFusion Web Developer / Consultant http://william.seiter.com Free Website Trade Publication >> Website Magazine http://www.websitemagazine.com/referrals/?id=51344&f=text2 Don't forget to answer the survey questions, it's a 10 second task , a very small request for access to this incredible resource. ::-----Original Message----- ::From: John Ahlen [mailto:[EMAIL PROTECTED] ::Sent: Saturday, September 06, 2008 8:28 AM ::To: CF-Newbie ::Subject: Query question :: ::Hello All, :: ::Problem: :: ::One table contains the responses to a 15 item quiz in numeric columns. ::Another table contains the correct answers to the 15 item quiz in numeric ::columns. I need to be able to evaluate the one table against the other ::and output the results in various forms. :: ::What would be the best starting point for this? :: ::I know this is a very open-ended question and I apologize in advance if ::it's too vague. But I think if I can just get an initial idea, I should ::be able to get it done. :: ::Thanks in advance, :: ::jahlen :: :: :: :: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3958 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
