RE: [CFTALKTor] Calculating Fields

[Steve Budan]

most efficient in terms of what? Its like asking whats the most efficient way of getting to montreal? train, car, truck? depends.

Steve 

-----Original Message-----
From: Arun Persaud [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 23, 2002 2:15 PM
To: [EMAIL PROTECTED]
Subject: [CFTALKTor] Calculating Fields

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