Replacing numbers with text at the query level

[lonesoac0]

Hello all,



I have a table that has numeric values for cities. I query for the information but it comes out as numbers that represent the cities and not their actual names. I would like to set it up in the query to replace the numbers with the actual names. I am pretty sure that this can be done in the Field row of the query designer, just not sure how to go about it.

[ranman256]

Use a translate table..say tCityNumConv.
[city]
[CityNum]

list all cities and their num values in the table.
Then Link this to your data table and it will translate it for you. Enter city names in the tCityNumConv.City critiera.
No code needed.

[June7]

Agree, create table then build query that joins tables.

[lonesoac0]

Cool beans. I will try it out. Thank you guys!

[lonesoac0]

That was perfect guys. I already had a table like you suggested already setup. I just replaced the field that contained the numbers to the field that contained the names and it worked.