How do I convert text to a number?

[Guest]

I am currently entering data for a survey that requires people to circle a b
c or d.
How can I convert the text letters to numbers? I can work out how to get a
total score once they are in number format, but at this stage I have to enter
the numbers rather than the letters. This is tricky becuase the a/b/c/d do
not always correspond to the same number across different questions (ie for
Q1, a=3 and for Q2 a=1), and it would be much easier if I could set the
translation to do it automatically.

Cheers, liz

 

[Amy Blankenship]

When you define the distractors for the question, give each one a point
value. So your table structure might look like this

Surveys
=====
SurveyID
SurveyName

Questions
=======
QuestionID
Stem
SurveyID

Distractors
=======
DistractorID
QuestionID
DistractorText
DistractorLetter
PointValue

Users
====
UserID
FirstName
LastName
etc

Sessions
======
SessionID
UserID
SurveyID
SessionStart
SessionEnd

SessionResponses
=============
SessionID
QuestionID
DistractorID

(actually if you know the distractor ID you know the question id, but this
way makes it easy to see what is happening)

HTH;

Amy

 

[Dale Fye]

Liz,

How are you building your survey? Are you giving them a text box, followed
by an option group from which they can only select one item. If so, each of
the radio buttons in an option group can have a value associated with it.
Access automatically numbers these from 0 to X-1, but you can give them
whatever value you want.