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

On Wed, 7 Feb 2007 11:57:00 -0800, wal50
<(E-Mail Removed)> wrote:

> 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]

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

"John W. Vinson" wrote:

> On Wed, 7 Feb 2007 11:57:00 -0800, wal50
> <(E-Mail Removed)> wrote:
>
> > 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]
>

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

"wal50" wrote:

> 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
>
> "John W. Vinson" wrote:
>
> > On Wed, 7 Feb 2007 11:57:00 -0800, wal50
> > <(E-Mail Removed)> wrote:
> >
> > > 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]
> >

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.

"wal50" <(E-Mail Removed)> wrote in message
news:4AE55DB3-69DA-4D55-9501-(E-Mail Removed)...
> 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
>
> "wal50" wrote:
>
>> 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
>>
>> "John W. Vinson" wrote:
>>
>> > On Wed, 7 Feb 2007 11:57:00 -0800, wal50
>> > <(E-Mail Removed)> wrote:
>> >
>> > > 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]
>> >