Query Assistance...

[Heidelberg]

In my query, I have 2 Columns: An "Assessment" column that has a single
letter evaluations, e.g.,"C". How do I have the "Confirmation" Column to
convert the "C" to "Confirmation", a "U" to "UnConfirmation", etc.

Would I need to use an IF clause somewhere?

Thanks for your help!

 

[J. Goddard]

Easiest would be to create another table used as a lookup table, and add
it to the query. The lookup table contains two fields, one is the
single letter code, and the other is the text decode value. Link the
two tables on the single-letter code fields, and in the query display
the decode text value instead of the single letter.

John

 

[Heidelberg]

Sounds like the right thing to do, but I'm not sure I know how to get a text
decode value. Could you take me through this step by step?

Thanks for your help!

 

[JJ]

So, I think john is saying that if the single letter code is 'u' then
it's text decode value would be 'unconfirmed'.

Basically a you want to make a simple table that explains what each
code means, something like this:

Code Status (aka "Text Decode Value")
U Unconfirmed
C Confirmed
F Finished
T Tested...


So now you have an extra table that explains what the letters mean.

You need to show how this table is related to your other table. So you
need to bring in this new table in the query along with your other
table and then you will need to link them. You want it to say that the
code in this new table equals the code in your other table. When you
query, instead of selecting 'Code,' just select "Status" and the
results will show the full word instead of the abbreviation.

Hope this helps.