i have a legacy access database where the last db guy set up linked tables text columns as number data types. Because they are linked, i cannot just go in and change the datatype to String (or is there a way to without screwing up all the linked tables?). I am trying to concatenate two of these columns as text and they keep appearing as numberical values. When opening the tables in Access, the data is shown as text, even though it is typed as a number. Does anyone have any suggestions on concatenating two text strings stored as numbers and outputting a text string?
FYI - I have already tried unsuccessfully to use cStr() and format(), but i may have misused them as far as correct syntax.