Sorry, I realized that I will need all the values for each question in a table, so I can view how each were ranked.
Thanks anyways. Arun. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: April 23, 2002 2:34 PM To: [EMAIL PROTECTED] Subject: [CFTALKTor] Calculating Fields If it was me, I would calculate the sum first, and then insert it. ************************* I'm looking for the most efficient way to do the following: I've have a questionnaire form with 10 questions. Each question is ranked 1 through 5 using radial buttons. What I'm trying to accomplish is finding the sum of the values of from all questions and place it into a table. Can I calculate the sum first on a process page and insert that value into the "sumQuestion" Column of following table: TABLE 1: rankID sumQuestions OR do I need to have all the values inserted first into a table like this and then process the values to arrive at a total for "sumQuestions" TABLE 1: rankID question1 question2 question3 question4 question5 sumQuestions Thanks Arun - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: [EMAIL PROTECTED] To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Arun Persaud" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
