calculated field to display numeric data from combo box as text

[tinjau]

I have entered numeric data into fields in evaluation of a number venue conditions.
Example fields are road, parking, fence, shade, etc...
Each field I entered a value 1-10 (meaning, 1 = unusable.... 5 = just OK... 10 = excellent condition)
I run a query to show just these the condition values for each field at each venue, to summarise the venue's condition.
How do I now display the value 1 as text "unusable", 5 as text "Just OK" etc..
Can I use a calculated field next to each field in my query to display the text meaning for each value, so I can also keep the numeric value?

 

[bob fitz]

Hi tinjau

Each field I entered a value 1-10 (meaning, 1 = unusable.... 5 = just OK... 10 = excellent condition)

I would create a new table for these values, with 2 fields. One field for the numerical rating and the second for the text. Then you could use the DLookup() function to return the text required, or you could use the new table (with a join to your main table) in your current query.

 

[tinjau]

Thanks so much Bob, DLookup worked fine (albeit took me a few tries to get the syntax correct), In my query I have added a calculated field next to each condition field so I can see what the values I entered actually mean, as follows example of a venue field condition:
FenceCondtn: DLookUp("[TBLX_RATING_LIKERTSCALE]![RatingValueMeaning]","TBLX_RATING_LIKERTSCALE","[RatingValue] = " & [FencingCondition]).
Very helpful Thanks again!

 

[bijuvijayaraj]

alternately you can use choose function from the expression builder.