Changing a number to a code

[Lee]

How do I change a number into a word? For example, I have a questionnaire
that has a likert scale (1=never, 2=often, 3=always). I enter the answer to
the question by typing in the number. How do I change the number to the word
(never, often or always)? Should I do that in the reports? If so, how? Any
help is appreciated

 

[Dave]

Check out the Choose() function. For example, if you have a variable intFreq
that has the value 2, then

Choose(intFreq,"Never","Often","Always")

returns "Often"

 

[Lee]

Thanks for responding Dave. Is the intFreq the name of the column where the
1,2,3 is? I tried to use the choose function for the question "Was this
medicine helpful" Choose([was this medicine helpful],"Never", "Often",
"Always") and it didn't work. Help!

 

[Dave M]

Do you really have a column named [was this medicine helpful]? I'm a big
believer in meaningful field names, but that's a beauty!

Anyhow, if you have a table named "MyTable" with a numeric field named
"Response" and it can have values between 1 and 4, a query that looks like
this

SELECT Response, Choose([Response],"One","Two","Three","Four") AS [Words]
FROM MyTable;

should show you the numbers and the corresponding words.

Thanks for responding Dave. Is the intFreq the name of the column where the
1,2,3 is? I tried to use the choose function for the question "Was this
medicine helpful" Choose([was this medicine helpful],"Never", "Often",
"Always") and it didn't work. Help!

Check out the Choose() function. For example, if you have a variable intFreq
that has the value 2, then

Choose(intFreq,"Never","Often","Always")

returns "Often"

answer
to the
word how?
Any

 

[Lee]

Hey Dave, no, I really don't have a column with that name. Thanks for the
instruction, I will try it.

Do you really have a column named [was this medicine helpful]? I'm a big
believer in meaningful field names, but that's a beauty!

Anyhow, if you have a table named "MyTable" with a numeric field named
"Response" and it can have values between 1 and 4, a query that looks like
this

SELECT Response, Choose([Response],"One","Two","Three","Four") AS [Words]
FROM MyTable;

should show you the numbers and the corresponding words.

Thanks for responding Dave. Is the intFreq the name of the column where the
1,2,3 is? I tried to use the choose function for the question "Was this
medicine helpful" Choose([was this medicine helpful],"Never", "Often",
"Always") and it didn't work. Help!

Check out the Choose() function. For example, if you have a variable intFreq
that has the value 2, then

Choose(intFreq,"Never","Often","Always")

returns "Often"

How do I change a number into a word? For example, I have a questionnaire
that has a likert scale (1=never, 2=often, 3=always). I enter the answer
to
the question by typing in the number. How do I change the number to the
word
(never, often or always)? Should I do that in the reports? If so, how?
Any
help is appreciated