recode query result

[desgordon]

Hello,

I want to run a query on an MS Access database table on columns where number are used as coded for building descriptions

e.g. for roof type:
1 = concrete
2 = zinc
3 = tatched

What I want to do is to return the result as the string. Is this possible using a single query in MS Access?

Thanks.

 

[pbaldy]

Typically there would be a second table with those options in it. In your query, you'd join the 2 tables together on the numeric field, enabling you to return the text field.

 

[desgordon]

Thanks Paul.

I really should have thought of that myself.

 

[pbaldy]

No problem, we all get brain cramps now and then.