Expression Question

  • Thread starter Thread starter Rabastan
  • Start date Start date
R

Rabastan

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?
 
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
 
Back
Top