Replace

[Guest]

I have this Macro that execute a query.I'd like to replace the column A
results...
Now they are numbers ...and I'd like to replace them with city names..
For example 50000 is Milan
500002 is Rome..
Is it possible??

 

[tina]

you need a table that contains the mapping data, as

tblCities
CityCode
CityName

one code/table combination per record, as

tblCities
CityCode CityName
50000 Milan
50002 Rome

in the query link the "columnA" in that table with the CityCode column in
tblCities, then add the CityName field to the query grid.

hth

 

[jonathan danek]

Don't send any more things