Reporting - Combo Box

[Guest]

This has got to be easy but I'm stumped.
I have a several combo boxes in a subform to select "Yes", "No" or "N/A"
(from a table). The form works fine. I want to report on the results of
each box. What I get on the report are the row values from the Table (1, 2,
or 3). How do I get the report to print Yes, No or N/A? Doing another query
to lookup the values seems silly. There must be another way.
Help is appreciated.
Thanks,
wal50

 

[John W. Vinson]

Doing another query
to lookup the values seems silly.

Well... then all Access applications are silly. Basing Reports on
multitable queries is perfectly normal and routine. Queries are your
friends - get to know and love them!

John W. Vinson [MVP]

 

[Guest]

Thanks for your help. Another query it is.
It just seemed that since the values were in a table that Access was using
to convert 1, 2, 3 to Yes, No, and N/A, there would be some way (that I was
missing) that could re-convert the numbers back to literals. Now I know that
there is a way and it's name is Query.
Thanks again for your (not silly) help.
wal50

 

[Guest]

But there is another question about the required Query.
The query I have matches general test information (class, etc) against the
answers. This query is the source that produces the report. The report that
I want to show Yes, No or N/A as the answers but now shows 1, 2, 3.
Each answer is a field, and there are ~40 questions/answers each test (same
all the time).
My question is about the query to convert the numbers to literal value.
Matching each answer to the table (40 times) doesn't work.
Is there a way to use current query (or another one)?
I tried creating a new field in a new query: Answer1Literal:
IIf([Answer1]="1", "Yes", Iif([Answer1]="2", "No", IIF([Answer1]="3",
"N/A"))). I was going to do that for each answer and use the result on the
report. Didn't work.

Any suggestions would be appreciated.
wal50

 

[Rolls]

Create a table with these records:

field1 Code
field 2 Description

1 - Yes
2 - No

You join the two tables on the key fields then substitute the description
field for the code in your select query result.

But there is another question about the required Query.
The query I have matches general test information (class, etc) against the
answers. This query is the source that produces the report. The report
that
I want to show Yes, No or N/A as the answers but now shows 1, 2, 3.
Each answer is a field, and there are ~40 questions/answers each test
(same
all the time).
My question is about the query to convert the numbers to literal value.
Matching each answer to the table (40 times) doesn't work.
Is there a way to use current query (or another one)?
I tried creating a new field in a new query: Answer1Literal:
IIf([Answer1]="1", "Yes", Iif([Answer1]="2", "No", IIF([Answer1]="3",
"N/A"))). I was going to do that for each answer and use the result on
the
report. Didn't work.

Any suggestions would be appreciated.
wal50

Thanks for your help. Another query it is.
It just seemed that since the values were in a table that Access was
using
to convert 1, 2, 3 to Yes, No, and N/A, there would be some way (that I
was
missing) that could re-convert the numbers back to literals. Now I know
that
there is a way and it's name is Query.
Thanks again for your (not silly) help.
wal50