No, I have one big table where the answers are coded by numbers, say, 1 to 4, and lots of other, small tables, mapping the coding, say, 1=" I agree strongly", 5="I disagree strongly", as well as handling missing answers and miscoding.

Currently I have solved the issue by having made several update queries, each handling ten fields each, and then running them all, but this seems like a very "clunky" and "naff"...

I have a table with about 50 integer fields (coded answers to questions), and equal number of tables where those integers correspond to short bits of text. (Human readable version of those answers.) I now want to produce either a query or a table where all the integers have been replaced with the corresponding bits of text.

Linking the integer fields result in an extremely slow query after 18 or so linked tables, and if I try to link...