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" <Rabastan[ at ]discussions.microsoft.com> wrote in message
news:1EE176A4-F124-4BDC-AECC-F33BFB5ECABB[ at ]microsoft.com...
[Quoted Text] >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?
>
>
|