If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Expression Question
I have a series three of drop downs on my site. Each one establishing a
criteria in a text answer. Each text answer has a scroe attached to it for example Question 1 answer 1 = 5 points answer 2 = 4 points answer 3 = 3 points Question 2 answer 1 = 5 points answer 2 = 4 points Question 3 answer 1 = 3 points answer 2 = 2 points Total Points Is there a way to use an expression to change the value of the stored answers to a numeric in order to add them for the total field? |
#2
|
|||
|
|||
Expression Question
Rather than modify the value stored, how about if you use a query to
"translate", using the IIF() function? Or, how about if you create a table that cross-references the "answer" with the "points", then use a query to "translate" to the points, joining on the "answer" fields? Regards Jeff Boyce Microsoft Office/Access MVP "Rabastan" wrote in message ... I have a series three of drop downs on my site. Each one establishing a criteria in a text answer. Each text answer has a scroe attached to it for example Question 1 answer 1 = 5 points answer 2 = 4 points answer 3 = 3 points Question 2 answer 1 = 5 points answer 2 = 4 points Question 3 answer 1 = 3 points answer 2 = 2 points Total Points Is there a way to use an expression to change the value of the stored answers to a numeric in order to add them for the total field? |
Thread Tools | |
Display Modes | |
|
|