Converting words to #s

[Mallinson]

Hi everyone, I'm writing out a series of questionnaires for a medical research group, and my people are asking me to create answer fields that appear as their original wording (e.g. "yes" or "no") in the form, but are codified into numbers (e.g. yes=1, no=0) in the table, so they can easily input that data into their system. Is this one of those obscure requests from boss to employee that takes the utmost tact to explain to them that it's impossible, or is there a simple way to do this? Thanks!

Edited August 14, 2009 by Guest

[comment]

It's not only possible - it should be rather trivial with the correct structure. The answers should be records, not fields. You didn't provide much detail, but normally it would be a table of Answers, with fields for:

AnswerID

QuestionID

Answer (the text)

Value (the number)

Note these are the answers provided for the subject to choose from - the actual responses would go into another table.